Forum Discussion
Solved
Get Current Week based on two conditions (Max Year and Max Week) based on selected filter
Hi, I wanto to created Current Week based on the Max Selected Year and Month, and the previous Week based on the Min Selected Year and Month. like this i already created measure for Current w...
adityo Well done, you're getting close. You'll need to add a Week Number column to your date table also, this can be done in Power Query.
Then, see if this blog helps: Calculating Weekly Sales w/DAX In Power BI | Enterprise DNA
Finally come back and let me know how you're getting on and what further questions you still have.
AllisonKennedy
Community Champion
Community Championadityo Well done, you're getting close. You'll need to add a Week Number column to your date table also, this can be done in Power Query.
Then, see if this blog helps: Calculating Weekly Sales w/DAX In Power BI | Enterprise DNA
Finally come back and let me know how you're getting on and what further questions you still have.
thank you so much AllisonKennedy it works perfectly 👍🏻