Date dimension · Learn Microsoft Fabric

Date dimension

In the gold layer I have a date dimension table. The facts table is linked to the date dimension based on a date key.

For this linkage I calculate based on the date in UTC format. Basically I find the corresponding DateKey in the date dimension table and I put that key in the facts table.

Now the issue is, that the reports in PowerBI should be made taking into account a timezone. The first solution was to create a default DateKeyTimezone and have the explicit key calculated based on the utc date + the coresponding timezone and have a DateKeyUtc to link to the corresponding date utc key. Basically the fact table will contain 2 Date keys. I don’t know if this is the proper solution.

How do you tackle this kind of problem ob your project? Do you have any tips&tricks?

Thanks!

1 comment