Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Daily YTD Average problem

Hi- I am spinning my wheels on how to calculate a Daily YTD Average (by month).  See sample table and power bi data below.   Thanks for your help!!!!   Nate
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    If you have a date table set up, then you should be able to write something like this

     

    CALCULATE ( AVERAGE ( TableEx[Rev] ), DATESYTD ( DateTable[Date] ) )
AlexisOlson's avatar
AlexisOlson
Super User
4 years ago

If you have a date table set up, then you should be able to write something like this

 

CALCULATE ( AVERAGE ( TableEx[Rev] ), DATESYTD ( DateTable[Date] ) )
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Worked!  Thank you very much!