Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Need a help on DAX Measure to create a period based on Week Number.
I want to combine 4 weeks into one period.
For example :
If Week Number is 1, 2, 3, 3 then a measure should display a period value as 1,
If Week Number is 4, 5, 6, 7 then it should display a period value as 2.
Can this be done with the help of DAX?
Solved! Go to Solution.
I think you can do something like:
4 Week Period Number = QUOTIENT(WeekNumber, 4)
I think you can do something like:
4 Week Period Number = QUOTIENT(WeekNumber, 4)
Yes, this worked for me.
Thanks for your help
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.