Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi.
I have a measure with this code:
Net Sales = CALCULATE(SUM(MainParamCalulations[ParamSum]), MainParamCalulations[Code] = "Sales")
MainParamCalulations is a table with a date field. I need to calculate its running total "as a measure" which uses "Net Sales" measure inside, becuase:
I have already tested this with no luck (it works exactly like Net Sales):
RT Net Sales = SUMX(FILTER(MainParamCalulations, MainParamCalulations[TransDate] <= MAX(MainParamCalulations[TransDate])), [Net Sales])
Any help is greatly appreciated.
Solved! Go to Solution.
Finally found a way to do this, of course probably not optimized, but works. There are steps:
1. Created a summarized table based on MainParamCalulations to extract existing dates, along with a bidirectional 1-to-many relationship with MainParamCalulations on TransDate:
Finally found a way to do this, of course probably not optimized, but works. There are steps:
1. Created a summarized table based on MainParamCalulations to extract existing dates, along with a bidirectional 1-to-many relationship with MainParamCalulations on TransDate:
@SajjadMousavi , join you table with Date table and try like
Cumm Sales = CALCULATE([Net Sales],filter(all('Date'),'Date'[date] <=max('Date'[date])))
or
Cumm Sales = CALCULATE([Net Sales],filter(allselected('Date'),'Date'[date] <=max('Date'[date])))
use column from date table in visual
Running Total/ Cumulative: https://www.youtube.com/watch?v=h2wsO332LUo&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=41
Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5b...
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.
Hi.
Thanks for your reply. Tested it, no luck. It returns the exact value as Net Sales. I re-wrote it as:
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
60 | |
57 |
User | Count |
---|---|
183 | |
111 | |
105 | |
77 | |
70 |