Forum Discussion

MarcF's avatar
MarcF
Icon for Advocate IV rankAdvocate IV
9 years ago

Last 'x' weeks with custom week format

Hi,     I need a boolean calculatation field to filter out the last 6 weeks of my date in oder to make a yoy comparison. However, I have a bespoke week format based on the week starting on Monday ...
Need Help
Show and Tell
MarcF's avatar
MarcF
Icon for Advocate IV rankAdvocate IV
9 years ago

Thanks that's a first working solution. However, I now have to find a way to rank the weeks on my bar chart from newest first (ie: 2,52,51 etc.). Would you have any idea on how to achieve that given that I need to compare weeks year-on-year? I was hoping there would be a way to get DAX intelligence time to work on custom weeks.

v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

MarcF

 

In DAX, there's no function for week level time intelligence, you have to custom your week based calendar, then build the week baesd time intelligence logic manually as BetterCallFrank suggested. 

 

Please refer to link below:

Week-Based Time Intelligence in DAX

 

Regards,