Forum Discussion
Formula Problem : IFHASONEVALUE, VALUES, CALCULATING SPEND WITH DIFFERENT TYPES OF COSTS
Hi everyone, I hope somebody can help me with this, and I hope everyone is good. I am a digital marketer, self taught DAX user, that has stumbled upon a problem bigger than me. Situation: ...
1: You can add a calculated column in your table to get the week number:
WeekNumber=WeekNum(Table[Date])
2.Use this in your table visual.
Generally, if you are doing fancy date things... you are going to want a separate date table, and relate it back to your main data table. I wrote this before Power BI, but should still apply... http://tinylizard.com/power-pivot-date-table
Averaging over any TimeUnit is going to use AVERAGEX (well, a SUM() and a divide by the count of time units...)
=AVERAGEX(ALL(Calendar[WeekNum]), [Some Measure])
(iterate over each of the Weeks, evaluating [Some Measure] for each and average the results together)