search

sql-bi / DaxDateTemplate

Power BI template to create a Date table in DAX
MIT License
267 stars 76 forks source link

Endofweek is displayed as week in ISOWeeks hierarchy #1

Closed EminUZUN closed 7 years ago

EminUZUN commented 7 years ago

image

marcosqlbi commented 7 years ago

This makes it easier to use it in charts - would you use another notation (e.g. W01...)?

ImkeF commented 7 years ago

Thanks a lot for sharing this comprehensive work! Is it possible to make the Last Date dynamic by referencing the date column of a budget table for example?

marcosqlbi commented 7 years ago

The columns named "RelativePos..." are there just for this purpose. They are created based on the distance from the processing day obtained using TODAY. You can replace that function with a formula based on another table (e.g. budget). Just modify the assignment of the first variable in the script, "TodayReference".

ImkeF commented 7 years ago

Thx, worked a charm!