How can i calculate percent variation of non-temporal data?

[vsilva82]

Hello everyone!

Please, i need help for a case! I have data non-temporal with some values where a need to calculate a percent variation between then, like this:

CINESEMANA	PÚBLICO	VAR%
1	1200
2	2200	83%
3	900	-59%

Somebody could help, please?

Thanks!

[parry2k · Accepted solution]

@vsilva82 if you want it to add as a column, use the following DAX to achieve the result. This is based on the assumption of the sample data you have provided.

VAR % as Column = 
VAR __currentRow = 'Table'[CINESEMANA]
VAR __prevRow = __currentRow - 1
VAR __prevRowValue = 
CALCULATE ( 
    MAX ( 'Table'[PÚBLICO] ), 
    ALL ( 'Table' ),  
    'Table'[CINESEMANA] = __prevRow 
)
RETURN 
DIVIDE ( 
    'Table'[PÚBLICO] - __prevRowValue, 
    __prevRowValue 
)

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

[vsilva82]

@parry2k , thank you so much! You helped here! 

I'll be training more about your metod to solve this problem!!

Thanks

[parry2k]

@vsilva82 Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[vsilva82]

Thank you, @parry2k !

I'll better my question!!