Forum Discussion

tasmiaa's avatar
tasmiaa
Advocate I
7 years ago
Solved

DAX question about static vs dynamic calculation

*I'm simplifying the math involved and the numbers aren't really representative of what I'm calculating    In Excel, 1. I have a calculation for a 3 Month Average Rate. The calculation takes the a...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi tasmiaa,

     

    You can calculate the 3 Month Average Rate with a calculated column. While create a measure to multiply it with dynamical "den" values.

     

    Regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

Hi tasmiaa,

 

You can calculate the 3 Month Average Rate with a calculated column. While create a measure to multiply it with dynamical "den" values.

 

Regards,

Yuliana Gu