topic Howcan i create a measure to show the profit percentage of last year to this year? in DAX Commands and Tips

Howcan i create a measure to show the profit percentage of last year to this year?

Danteee — Tue, 21 Nov 2023 12:47:10 GMT

Hi friends,

I have created a matrix column for profits of previous years and months,i now need to show the profit grow percentage compared to the previous date,how can i do that ?

Thanks

Re: Howcan i create a measure to show the profit percentage of last year to this year?

AnalyticPulse — Tue, 21 Nov 2023 13:00:07 GMT

I assume you have the date table in your data model.
Use below measure for calculating Profit %:

ProfitGrowthPercentage =
DIVIDE(
YourData[Profit] - CALCULATE(SUM(YourData[Profit]),
FILTER(YourData, YourData[Date] = YourData[PreviousDate])),
CALCULATE(SUM(YourData[Profit]),
FILTER(YourData, YourData[Date] = YourData[PreviousDate]))
)

result of this formula will be a percentage representing the profit growth compared to the previous date. If the result is positive, it indicates an increase in profit, and if it's negative, it indicates a decrease

If this helped, Subscribe AnalyticPulse on YouTube for future updates:
https://www.youtube.com/@AnalyticPulse
https://instagram.com/analytic_pulse
https://analyticpulse.blogspot.com/

please subscribe to Youtube channel For fun facts:
https://www.youtube.com/@CogniJourney

Re: Howcan i create a measure to show the profit percentage of last year to this year?

v-zhangti — Thu, 23 Nov 2023 07:15:06 GMT

Hi, Danteee

You can try the following methods.
Measure:

Previous date value = Var _Previousdate=MAXX(FILTER(ALL('Table'),[Date]<SELECTEDVALUE('Table'[Date])),[Date]) Return CALCULATE(SUM('Table'[Profit]),FILTER(ALL('Table'),[Date]=_Previousdate))

Measure % = Var _divide=DIVIDE(SUM('Table'[Profit])-[Previous date value],SUM('Table'[Profit])) Return IF([Previous date value]=BLANK(),BLANK(),_divide)

Is this the result you expect? Please see the attached document.

Best Regards,

Community Support Team _Charlotte

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