Forum Discussion
Suhel_Ansari
Helper V
Helper VDAX Measure Formula to Calcualte Running Fleet
Hi DAX Expert, I need your help to calculate the Running Fleet formula as Measure in Power BI DAX, the calculate as as shown below. The Date-Year column is a actual Date. Growth = [Registrations]-...
- Create this measure:
TotalGrowth = CALCULATE ( SUM ( 'Table'[Growth] ) )
And then this one:
Cumulative Growth = IF(MIN([Date-Year])<=CALCULATE(MAX([Date-Year]),ALL('Table')),CALCULATE([TotalGrowth],FILTER(All('Table'[Date-Year]),'Table'[Date-Year]<=MAX(('Table'[Date-Year])))),BLANK())
Let me know if that works for you!
Greg_Deckler
Community Champion
Community ChampionSo are you saying that the image is what you want or that it is incorrect? What is your source data? I do not understand your formulas " + Date 2016" for example, what is that?
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Suhel_AnsariHelper V
Helper VGreg_Deckler .. The Data Source is SQL View. Thanks