Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Extracting from Measures in Smart Narrative Visual

Hi,

I would like to extract a figure from a measure in a smart narrative visual in order for it to show the figure for the last month of my power bi (the last month changing dynamically every month). For example, I'd like to have the 113,27% for December (= "décembre") on the screenshot below. I tried using various combinations of "last month" and my measure's name ("% variation ...") but haven't been able to have the requested result; all I had was 34,56%.

 

Thank you for your help!

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous ，

    Try creating a measure like this one and filling it right in here.

    Last Month Variation en % .. = 
VAR _max_month = MAXX(ALLSELECTED('Table'[Month Number]),'Table'[Month Number])
VAR _max_month_value = CALCULATE([Variation en % ..],'Table'[Month Number]=_max_month)
RETURN
_max_month_value

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi Anonymous ,

      Thanks a lot for your response! However, I haven't been able to have the results I wanted. I think that our main difference is that: your first measure is a sum whereas mine is the difference for a data between a month and the month before; I haven't specified this, my bad. When I use your reply as a model for a measure being a SUM, it works! But, not with my measure... (which is a quick measure by the way!)
      Is it possible to work with this sort of measures and have the last month' value too?

      Thank you!
      Best regards.