search

sql-bi / DaxDateTemplate

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

Does it include the week of the quarter? #31

Closed ThibaultBagot closed 4 years ago

ThibaultBagot commented 4 years ago

It'd be interesting to look at the week of the quarter typically from 1 to 13 instead of the 53 annual weeks. What do yo uthink? Is it already in there?

marcosqlbi commented 4 years ago

You can just create a column using MOD ( 'Date'[FW WeekNumber] - 1, 13 ) + 1, which works well for 52 weeks (ISO Calendar). Because there are no standards about managing the 53 weeks, you should figure out a business logic that can be good for your requirements. It's hard to create a generic solution for that.