Forum Discussion

ChrisB1977's avatar
ChrisB1977
Frequent Visitor
7 years ago
Solved

Using measures in rolling 6 month averages

Hi,   I'm having trouble working out a rolling average   I have a measure I've created: Sentiment PosNeu = table1[Positive+Neutral Sentiment] /table1[Positive+Neutral+Negative Sentiment]   Thi...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi ChrisB1977,

     

    Please use this formula to create a calculated column instead of measure. If it doesnt' work, kindly share your sample data or pbix to me.

     

    Sentiment PosNeu = table1[Positive+Neutral Sentiment] /table1[Positive+Neutral+Negative Sentiment]

     

    Regards,

    Frank

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

Hi ChrisB1977,

 

Please use this formula to create a calculated column instead of measure. If it doesnt' work, kindly share your sample data or pbix to me.

 

Sentiment PosNeu = table1[Positive+Neutral Sentiment] /table1[Positive+Neutral+Negative Sentiment]

 

Regards,

Frank

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

    Hi ChrisB1977,

     

    Does that make sense? If so, kindly mark my answer as a solution to close the case.

     

    Regards,
    Frank