Running Total or Cumulative Total of Non Date Columns - Power BI DAX Tutorial (29/50)

preview_player
Показать описание
How to calculate Running Total in power bi dax
how to get Cumulative Total of Non Date Columns in power bi dax
What is Running Total in power bi
What is isonorafter Dax fucntion

#PowerBI #PowerBIDAX #DAX

Complete Playlists

BI Developer - Complete Reference - Playlist
BI Architect - Complete Reference - Playlist
Рекомендации по теме
Комментарии
Автор

As you said not working when you put asc in the calculation It not works even when yo made the first column descendeing and cumulative totals showing wrong way with desc in the calculation ( It should show cumulative from top to bottom irrespective how you ordered the first column)

vykuntaraotangudu
Автор

Did you ever make a video showing how to integrate rank to get a cumulative sorted based on the total? Very informative videos!

PraxeoIogy
Автор

when i clear all filter, power BI got hanged for long time and shows huge data size error. my data size is less than 5 lakes rows. any suggestions..

karthickudt
Автор

Hi Nag i saw your above video but the running total measure is not showing correct values can you please help me out

sumitbansal
Автор

Hi, i have a data set of 17mio rows where there is not date column. I've written a DAX measure for running total of the values. Same measure works file with small data set But it takes huge time to execute in this 17mio data set.
DAX is
CALCULATE(
SUM(Table1[Val]),
FILTER(ALL(Table1), Table1[Val]<=MAX(Table1[Val])),
VALUES(Table1[SKU Code]))

Anything important that i'm missing?

NasirUddin-opit
Автор

Nicely explained!
I was tring to find the second part of video where we want cumulative total based on total sales sorting, can someone help

adnanshaikh
Автор

Hi, please help me how to write dax, I want to running total exclude current month.

surender
Автор

Have you made a video like you mentioned on how to display a running total based on 'total sales' measure?

jim_
Автор

I like the beginning music. So soothing 😊

ashu
Автор

This is the second time I have stucked in PowerBI in such a way that for last 4-5 days no one has been able to solve my problem related to running total for non-date columns. But bro - your this video, I watched only once, and it worked like anything for me. Thank you champ.. thanks a ton. I just joined your telegram channel. Thanks again

ratanbhushan
Автор

I tried this syntax but my result in grand total is infinity.

superlhily