Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I've created a DAX for segregating dates into the half-yearly categories i.e. "1st Jan - 30th Jun" & "1st July - 31st Dec". However, I'd need to make it more dynamic like the below format:
30/06/2021 falls on a Thursday and 01/07/2021 is on a Friday. When I use the weeks to show my data, the same week is calculated twice on the two "half-yearly categories"
Year | Period | Week Count | Value |
2021 | 1st Jan - 30th Jun | 27 | 950 |
2021 | 1st Jul - 31st Dec | 27 | 840 |
The week Count should be adjusted based on the dates given in the table. Can anyone help me with this?
Thanks in advance!
Hi,
Can you show us the formula you are using ?
hi @AilleryO ,
I'm using WEEKNUM() DAX in my formula. this is giving me the week count, however, if the last date of the month is coming in between the week then that week is calculated twice.
For the "half-yearly" category, I'm using the IF statement and Month no. to get the results
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
111 | |
96 | |
96 | |
67 | |
63 |