Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

DAX

Hi,

 

I have a dataset of production values with dates and a flag column indicating the first production value in the series.

 

Is it possible to force a measure to divide the flagged values by 12 and take an average of the remaining values?

 

Thanks

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Try

    calculate(averagex(filter(table,table[flag]=1),value/12))
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      amitchandak Thanks you for your response.

       

      This works to give me the correct single value for flagged data point but does not produce an average for the remaining months i.e. all remaining months are null.