Forum Discussion

jpriemer's avatar
jpriemer
Advocate I
5 years ago
Solved

Using smart narrative to calculate difference between two values

I am using smart narrative and am able to create individual values but I want to now be able to calculate the difference between the two values. Is this possible using smart narrative? The bold indicates the text I use to create each indiviudal value. You would think I'd be able to add "differece from" to this and have it work? Any advice? 

 

"difference previous pipeline value for Pipeline Value (header) from product value Open (opportunity status)"

  • jpriemer you can create a measure from the difference and then add it into the narrative.

     

    Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to 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.

2 Replies

  • jpriemer you can create a measure from the difference and then add it into the narrative.

     

    Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to 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.

  • Thank you. Yes, I was trying to avoid using another measure and only use the Smart Narrative, but perhaps its not as advanced yet. Appreciate your help!