Week Number by Fiscal Year

[Anonymous]

Hi,

I'm trying to create a calculated colunm that groups dates into one of three values.

Current Week - all dates that are in this month

Previous Week- all dates in previous month

Historic - all dates in the past that do not meet the criteria above.

Is this even possible? if so how would i go about writing this Dax?

[az38]

@Anonymous 

are you sure the topic is correct?

you have created the same here https://community.powerbi.com/t5/Desktop/Dax-for-Current-Month-amp-Previous-Month/m-p/871991#M418209

do not hesitate to give a kudo to useful posts and mark solutions as solution

[Anonymous]

Hi @az38,

Thanks for responding to this and my earlier post. 

I'm pretty much trying to do the same but based on weeknumber instead Month.

[v-chuncz-msft · Accepted solution]

@Anonymous 

You may simply use DATEDIFF.

DATEDIFF ( 'Table'[Date], TODAY (), WEEK )