Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have a data set where my datetime is for every 1 minute data and i need the moving average values for 15 minutes.
the date related filters are just for months, days and years. Any ideas on how to make this on a minute base?
Thanks,
For your requirement, you can add an [1 min ago] column in your table like:
1 min ago = Table[DateTime]-1/(24*60)
I assume you fact data is on second level. You can create the moving average measure like below:
1 min Moving Average = CALCULATE ( AVERAGE ( 'Table'[Amount] ), FILTER ( ALL ( 'Table' ), 'Table'[DateTime] <= MAX ( 'Table'[DateTime] ) && 'Table'[DateTime] >= MAX ( 'Table'[1 min ago] ) ) )
Regards,
Can you please explain the formula? It works but I am not able to understand properly.
Thanks
Krishna
Dear Simon
I have added a 15 min ago column and did the same code as you but the value calculated was the same for the all the column.
15min ago = Data[Date_Time]-15/(24*60) - This got the readings that i wanted.
NO 15min = calculate( AVERAGE(Data[NO Ref]);filter(all(Data);Data[Date_Time]<=Max(Data[Date_Time]) && Data[Date_Time]>= Data[15min ago]))
I am using values as dd/mm/yyyy hh:mm, should i use it as decimal?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
95 | |
77 | |
65 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |