How to calculate Running total for date values in Power BI
#dax #powerbi_training #powerbidax
In this video we see how to calculate the running total for dates in power BI.
We use the Adventure works data set and import Fact internet sales table.
we just pull in two simple columns i.e Order date and sales amount .
In order to create the running total we have to first of all create a measure .The measure is named RT for Dates and is the following .
RT for dates =
CALCULATE( [Sum_Sales],
FILTER(ALL(FactInternetSales[OrderDate]),
FactInternetSales[OrderDate] less than or equal max(FactInternetSales[OrderDate])
)
)
This is a really useful feature that can be used to keep track of information in your reports.
Once you know how to do this, you'll be able to track your progress in your reports and see how your data is changing over time. This is a really useful feature and one that you should definitely learn how to use!
Check out other Power BI Tutorials Videos :
1.SamePeriodLastYear with Example: • difference between parallelperiod and same...
2.How to Calculate Running Totals: • How to calculate running total in power bi
3.Duplicate Vs Reference : • power bi difference between duplicate and ...
4.Merge Vs Append: • power bi difference between merge and append
5.Calculate Function in DAX Power BI: • What is Calculate Function in Power BI DAX...
6.Filter Function in Power BI: • Filter Function in Power BI DAX
7.Row Vs Filter Context: • Row Context Vs Filter Context in Power BI
8.ALL DAX Function: • How to use ALL Dax Function in Power BI | ...
9.ALL Vs ALLSELECTED : • allselected dax|all vs allselected dax | p...
10.ALL Vs ALLSELECTED VS ALLEXCEPT : • All Vs AllSelected Vs AllExcept | Power BI...
11.ALL Vs REMOVEFILTERS : • ALL Vs REMOVEFILTERS Difference in Power B...
12.TOPN Dax Usage : • TOPN Dax | How to use topn dax in power bi...
13.Summarize Dax Function in Power BI: • summarize dax | How to use summarize in DA...
14.Summarize Vs Summarizecolumn : • summarize vs summarizecolumns | how to use...
15.Calendar Vs CalendarAuto : • Calendar Vs Calendar Auto Dax Function| Po...
16.How to create a date table in Power BI : • how to create a date table in power bi: st...
Learn Power BI through our vlog and Free Videos:
https://powerbizone.com/category/arti...
You can download the pbix file for your self practice sessions from :
https://drive.google.com/file/d/1AeNZ...
Do not forget to Like ,Subscribe and comment which keeps me motivated !