Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I need to be able to calculate measures where the week is defined as Friday to Thursday. I have a calendar in which I'd like to concatenate the start and end dates for these periods as a filter also. Can anyone help?
e.g. "28th February to 5th March"
Thanks for any help
Solved! Go to Solution.
Hi!, you can do this. In order to build calculations in date you need a Calendar Table to accomplish Time Intelligence. You can check how to do one here:
https://blog.ladataweb.com.ar/post/185012464051/data-modeling-como-hago-una-tabla-fecha
In your Date table (with power query) you can use something like this:
Date.WeekOfYear([DateColumn], Day.Friday)
You can also add this week with dax using WEEKNUM
Regards, hope this helps
Happy to help!
Hi!, you can do this. In order to build calculations in date you need a Calendar Table to accomplish Time Intelligence. You can check how to do one here:
https://blog.ladataweb.com.ar/post/185012464051/data-modeling-como-hago-una-tabla-fecha
In your Date table (with power query) you can use something like this:
Date.WeekOfYear([DateColumn], Day.Friday)
You can also add this week with dax using WEEKNUM
Regards, hope this helps
Happy to help!
User | Count |
---|---|
98 | |
90 | |
78 | |
72 | |
65 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |