Forum Discussion

tasmiaa's avatar
tasmiaa
Icon for Advocate I rankAdvocate I
8 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
    8 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
Icon for Microsoft Employee rankMicrosoft Employee
8 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