Running Total in Power BI (for Date and Non Date Values)

Let's dive in Running Totals for Date and Non Date Values.

- - - - My Courses - - - -
✔️ Mastering DAX in Power BI -

✔️ Power Query Course-

✔️ Master Excel Step by Step-

✔️ Business Intelligence Dashboards-

- - - - Blog - - - -

- - - - Download File - - - -

[stevencampbell]

Thanks, exactly what I needed, cumulative sum not dependent on dates! I also like the fact that you don't waste any time in your presentation

[angadsinghtoor]

I wasted my whole day finding the solution and I gave up. But you came as a hope for me. Thanks very much

[dapperlink]

I just beat my head against the wall trying all others solutions using the IF with ALLSELECTED and BLANK to stop cumulating on blank rows. I try your simple IF statement and BAM! Worked!

[kumargaurav]

Great Video. I tried to find the logic for calculating the same but did not get the results. Thanks to you for creating this video and answering my query. I actually find another way to do so. Using SELECTEDVALUE:
CALCULATE(
[Total Sales],
[Product Column] <= SELECTEDVALUE[ Product Column],
ALL( [Product Column] )
)

[pupycron]

this is great and you made it so simple. I was in for the non date version. 4 minutes and I get it!

[kummithavenkatareddy]

Honestly, its amazing the way you are explaining like the Execution of DAX in Complex queries. I liked it. Suggest best books for that

[hk_k]

did we have running total quick measures 3 years ago? This one is fab and now I finally
understand the logic behind.

[mlkabir]

Precise, concise yet thorough. Like it !!!

[williamarthur]

One thing, thank you for showing the if ( total sale <> Blank(), I'd been trying to use
" " as you would in excel and ending up with nothing at all, it's one of those DAX functions that makes sense along with M's 'then ' and 'else', but is a bit of a hindrance when you've been used to how excel works for decades.

[jeramzPC]

I've been looking for the solution to remove the months that don't have value. Didn't realize it had to have that IF statement. Thank you so much!!!

[michaelpacia]

Straight to the point presentation! You did a great job Bro!

[abinandan_a]

Thanks man !! Second half was tricky, couldn't find elsewhere.

[miosotisazul]

Hi. great explanation! Is it possible to show this last running total for non date field in percentage? So that the last row will equal 100%.

[InderjeetSingh-qitd]

Thank you Chandeep for the explanation. Very useful, however, one query, what if the Total Sales are same for 2 products? Does it provide correct total?

[ardenzhuo]

The second time you did the rankx, where PdtRank >= Rankx…

How is that different from the variable defined in previous step?

Can we use PdtRank >= PdtRank?

[MarkBrady]

Thanks for all of your videos. You really fit with my learning style.

[cesarsaldana]

Hi Goodly, what happens when you have several sellers with the same sale, you have to have a tiebreaker criterion because if you don't, the rank formula fails.

[shoaibrehman]

Hi Chandeep, your way of teaching is gr8 relate to this topis i am unable to resolve the issue when you performing a running total by category and then by months.
Means Products A, B and C orders running total in month of Jan, feb ... etc.
Could you pls explain in next videos.
Thanks in advance

[sukhomoyb]

Hi Chandeep,
Great tips dear. We would be grateful if you please show us a tricks on periodic average. In detail, say for an example. I need to create a measure to asses our sales; on current or selected months sales vs prior 3 months average sales; current or selected weeks sales vs prior 4 weeks average sales; or Today or selected days sales vs prior weeks average(last 7 days) sales. I am not expecting a single measure can give all the above answers but the way or a snippet to get answers for each above case.
Hope all your followers would be benefited with this tricks.
Thanks in advance. Sukhomoy

[patrickkinbonso]

Amazing.

How about the running total refresh anew on each different product?