Forum Discussion

fmaestri's avatar
fmaestri
Frequent Visitor
2 years ago

Measures with Field Parameters

Hi, I've seen this question or topic a lot but could not find the answer. I need to operate with the values of different columns selected from a field parĂ¡meter.

I want to show in a card the variation between the very first date and the last one, of the selected column. Is there any easy way? I can't even get the first or last value of the selected variable. 

Edit: This is what I got
Parameter= { ("ProductA", Sales[ProductA]), ("ProductB", Sales[ProductB]), ("ProductC", Sales[ProductC]) }
All from a Sales table, with a Date column. 

I want to show the difference between the sales of last month compared with the very first month. Eg.: Porcentual change between january 2024 (last value) vs march 2021 (first value). And show it in a KPI card or somewhere.


Thank you! 

2 Replies

  • Daniel29195's avatar
    Daniel29195
    Community Champion

    fmaestri 

     

    can you please share a visual reprresentation of what you want to achieve ? 

     

    best regards,

    • fmaestri's avatar
      fmaestri
      Frequent Visitor

      Yes, I tried to expliain it better now