Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
95 | |
94 | |
80 | |
71 | |
64 |
User | Count |
---|---|
115 | |
106 | |
96 | |
81 | |
72 |