Forum Discussion
Week Number by Fiscal Year
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?
3 Replies
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
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.
