Forum Discussion
Accumulate % for current month
I have a measure that calculates a % for each day based on a division of two column from a table, I want to show an accumulated % for current month, for example december, from 1st to the 16th... is it possible? I'm guessing doing a measure with the sum of the two tables just for the current month. Does it makes sense?
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
4 Replies
- amitchandak
Super User
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/823601thanks 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:
- amitchandak
use didvide([Ontime Lines],[Late Lines]) and see if still have the issue
amitchandak I accept your solution, I figured it out thanks to your help... and the help of the people on the other posts...
CumulativeOTD2 = TOTALMTD([OTD], Dates[Date], Dates[IsCurrentMOnth])