Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello peers.
I have been giving this task to implement Week to Date running Total in Power BI Desktop. I have been scratching my head over this.
I haven't found anything on Google Related to this.
What I did found out was to calculate Week to Date and Running Total measure.
Will request you people to kindly help.
I have calculated Week to Date as below;
Regards,
Sanket Bhagwat
Solved! Go to Solution.
Hi, @SanketBhagwat
In my opinion, it is better to have the WeekOfYear-number column in the dim-date-table and write the below measure.
Please check the link down below, that is the sample pbix file.
WTD =
CALCULATE (
Sales[Sales Total],
FILTER ( ALLSELECTED ( Dates[Date] ), Dates[Date] <= MAX ( Dates[Date] ) ),
VALUES ( Dates[Week of Year] )
)
https://www.dropbox.com/s/ehrgi2f3z71gqyj/sanket7030.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Hi, @SanketBhagwat
In my opinion, it is better to have the WeekOfYear-number column in the dim-date-table and write the below measure.
Please check the link down below, that is the sample pbix file.
WTD =
CALCULATE (
Sales[Sales Total],
FILTER ( ALLSELECTED ( Dates[Date] ), Dates[Date] <= MAX ( Dates[Date] ) ),
VALUES ( Dates[Week of Year] )
)
https://www.dropbox.com/s/ehrgi2f3z71gqyj/sanket7030.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Thank you @Jihwan_Kim .Will check with my team whether the answer is right or not.
Appreciate your help.
Regards,
Sanket Bhagwat
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
11 | |
9 | |
6 |