Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

HELP! - Display latest calculated Period in Totals

Hello!

 

Can someonple please help to know how can I manage to display the last calculated period into the total?

 

I imagine it is through vVriables and I have tried but I havent been able to achieve it.

 

This is the measure for the Cumulative Rotación vs LY %:

Cumulative Rotación vs LY Dif % = IF(today()<[Fecha Cierre Periodo],0, DIVIDE([Cumulative Rotación +],[Cumulative Rotación LY]) - 1)

 

The one who help me with this will go to heaven!!!! Thak you in advance!!

 

Anotación 2020-03-18 141458.png

1 ACCEPTED SOLUTION

Hi @Anonymous ,

 

Please new a measure like that to work on it.

new= SUMX(your table, [Cumulative Rotación vs LY Dif %] )

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

View solution in original post

4 REPLIES 4
camargos88
Community Champion
Community Champion

Hi @Anonymous,

 

I think you can solve it using the HASONEVALUE function, just test it with an if to change de code for total.

 

https://docs.microsoft.com/en-us/dax/hasonevalue-function-dax

 

 

Ricardo

 



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



Anonymous
Not applicable

Thank you but how would type or write the measure? 

Hi @Anonymous ,

 

Please new a measure like that to work on it.

new= SUMX(your table, [Cumulative Rotación vs LY Dif %] )

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.