Forum Discussion

martinkoe's avatar
martinkoe
Icon for Helper I rankHelper I
5 years ago

Multiple values of different dates

Hi,

 

assuming we have "today"(=23.07.2021) , i would like to multiple the last years Total sales (available as measure with Date[date] 31.12.2020 LYTS = 10 ) with a todays measure called "X" (X @ 23.07.2021  = 0,15) so i get a value with today [email protected] =1,5

 

/thx M

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    If they are both already measures can you create a third measures which multiplies them together?

    • martinkoe's avatar
      martinkoe
      Icon for Helper I rankHelper I
      5 years ago

      unfortunately not, as the measures multiple the values of the same date.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi  martinkoe ,

     

    Not very clear... can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.