Cumulative percentage as a constant line at the end of month

[kkalyanrr]

Hello Team,

I'm trying to get the Percentage month on month and cummulative percentage(as a constant line) at the end of last month.
Here are the dax expressions I'm using 

Profit Margin Percentage = 

DIVIDE( SUM('Profit Margin'[Profit (Actual)]) , SUM('Profit Margin'[Authorised Total (Inc. GST)]) ,0)

Profit Margin Cummulative Percentage=

Var a = MIN( 'Calendar(Profit Margin)'[Date])

Var b = MAX('Calendar(Profit Margin)'[Date])

Return

CALCULATE( [Profit Margin Percentage] , FILTER( ALLSELECTED( 'Profit Margin') , 'Profit Margin'[Date] >= a && 'Profit Margin'[Date] <= b ))
The lines are overlapping with one another.

[v-lionel-msft]

Hi, @kkalyanrr ,

Has your problem been solved?

If yes, please consider accept it as the solution to help the other members find it more quickly.

If not, please give us the sample data tables. Please post sample data for the columns used in your formula.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@kkalyanrr you should be using dates from your calendar table (seems like you have it in your model) instead of from profit table

Cummulative = 
CALCULATE ( [% measure], FILTER ( ALL ( CalendarTable ), CalendarTable[Date] <= MAX( CalendarTable[Date] ) ) 

you can change the logic as it fits into your business requirement.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem.

It is a token of appreciation! ⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡