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!
joshlwulf
Helper I
Helper IGreat to hear, Suhel_Ansari! I'll definitely keep this post in mind. I could see where this would be really useful in some situations.
Suhel_AnsariHelper V
Helper VEven I will keep it in my mind for ever.. Thanks for all your prompt response.
Regards
Suhel