Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello Guys,
everyone knows the quick measure of running totals or the DAX function YTD. I want to calculate the month over month change of a running total.
Is there a best practice dax expression?
Solved! Go to Solution.
I have found it out myself. It seems to be working. Here the resolution
1. Step: Sum the initial variable "Sales" sales = SUM( [Sales] ) 2. Step: Calculate the cumulated value of "sales" sales **bleep** = CALCULATE( [Sales]; FILTER( ALLSELECTED([Date]); ISONORAFTER([Date]; MAX([Date]); DESC) ) ) 3. Step: Calculate the percentage difference between 1 and 2 Sales **bleep** MoM% = DIVIDE( [Sales] ; [Sales **bleep**] - [Sales] ; 0 )
I have found it out myself. It seems to be working. Here the resolution
1. Step: Sum the initial variable "Sales" sales = SUM( [Sales] ) 2. Step: Calculate the cumulated value of "sales" sales **bleep** = CALCULATE( [Sales]; FILTER( ALLSELECTED([Date]); ISONORAFTER([Date]; MAX([Date]); DESC) ) ) 3. Step: Calculate the percentage difference between 1 and 2 Sales **bleep** MoM% = DIVIDE( [Sales] ; [Sales **bleep**] - [Sales] ; 0 )
Ok then may I ask you to mark your post as solution so others can find it more easily?
So you mean Month-to-Date?
Like this here?
If the post was helpful pls mark it as solution and share sume kudos 🙂
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
107 | |
105 | |
89 | |
61 |
User | Count |
---|---|
168 | |
138 | |
134 | |
102 | |
86 |