Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

How to Multiply measure with calender's table

Hi,

i create measure  Potential GP = [DBD Traffic]*[Highest Rev/traffic] which i want to multiply with number of date days

for example,   protenial trand = iferror([Potential GP]*[calender(days)],0)

 

how that will possible?

Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi, Anonymous 

    You could use this formula as below:

    Measure = [Potential GP]* DAY(SELECTEDVALUE(calender[Date]))

    Of course, you could nest them with other functions

    Result:

     

     

    Best Regards,

    Lin

2 Replies

  • v-lili6-msft's avatar
    v-lili6-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    hi, Anonymous 

    You could use this formula as below:

    Measure = [Potential GP]* DAY(SELECTEDVALUE(calender[Date]))

    Of course, you could nest them with other functions

    Result:

     

     

    Best Regards,

    Lin