Forum Discussion
Accumulate % for current month
For cumulative like this
Cummalative mtd = TOTALmTD(sum(Sales[Sales Amount]),filter(all(Sales[Sales Date]),Sales[Sales Date]<=maxx('Date',('Date'[Date]))))Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
For cumulative like this
Cummalative mtd = TOTALmTD(sum(Sales[Sales Amount]),filter(all(Sales[Sales Date]),Sales[Sales Date]<=maxx('Date',('Date'[Date]))))
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
thanks for your reply amitchandak , if I understood correctly I translate the formula to my needs like this:
CumulativeOTD = TOTALMTD(SUMX('OTD RAW DATA', [Ontime Lines]/[Late Lines]), FILTER(ALL(Dates[Date]), Dates[Date]<=MAXX(Dates, Dates[Date])))
I don't think I'm doing it right because when I put a card visual I get "infinity" 😞
I have tried solutions proposed on these post but with no positive result:
use didvide([Ontime Lines],[Late Lines]) and see if still have the issue