Hi Fellow Power BI Users -
I have a simple but somehow complicated task at hand.
I am supposed to build a stacked column chart showing the following:
The problem I have is showing the avg 12 mnth and the avg last mnth as columns. They can be interpreted as 30 and 360 days, like this:
MA 30 = AverageX( DATESINPERIOD( 'mart DimCalendarDaily'[CalendarDailyKey]; LASTDATE('mart DimCalendarDaily'[CalendarDailyKey]); -30; DAY); [Waste Water actual])
My problem is that it only works in a table, where the context is a date column.
What I wanted to do was to calculate 9 measures and show them as a column: Like MA 30, MA 360, Today - 6, Today -5, …Today.
Any idea how to solve the above?