Week Count DAX

[Maheshguptaz]

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!

[AilleryO]

Hi,

Can you show us the formula you are using ?

[Maheshguptaz]

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