Forum Discussion

legrand's avatar
legrand
Helper I
7 years ago
Solved

Average per weekday

So I've searched the forums but haven't found a solution yet...   I got a table with values which I can of course easily sum by date. I also have a date table in my data model which has a working r...
Need Help
  • legrand's avatar
    legrand
    7 years ago

    Ok, so apparently the solution is much simpler than I thought...

     

    Average per Weekday = AVERAGEX(Date Table;CALCULATE(SUM('Table'[Value])))
legrand's avatar
legrand
Helper I
7 years ago

Ok, so apparently the solution is much simpler than I thought...

 

Average per Weekday = AVERAGEX(Date Table;CALCULATE(SUM('Table'[Value])))