Forum Discussion
Helper IIssue with rolling average based off item type
hi JohnFabric
This reference shows how to use concat to check if the moving average is calculated as expected.
How to Calculate Moving Averages in Power BI - The Ultimate Guideyou can modify the "Dates in period" part of the DAX code to put in the required MA period.
Lastly, if you apply a visual level filter using Workitem Type on the matrix, you could have 3 visuals filtered with the same DAX code.
hope this helps. let me know if this resolves the issue.
if it doesn't, kindly upload a sample input (masking sensitive information) in a usable format such as table, csv, excel etc. and a sample output.
Memorable Memberhi JohnFabric
This reference shows how to use concat to check if the moving average is calculated as expected.
How to Calculate Moving Averages in Power BI - The Ultimate Guide
you can modify the "Dates in period" part of the DAX code to put in the required MA period.
Lastly, if you apply a visual level filter using Workitem Type on the matrix, you could have 3 visuals filtered with the same DAX code.
hope this helps. let me know if this resolves the issue.
if it doesn't, kindly upload a sample input (masking sensitive information) in a usable format such as table, csv, excel etc. and a sample output.
JohnFabricThanks, I was able to figure this out based on the video. I needed to change my formula. Each time I listed
Query1'[CompletedDateSK]I needed to change it to
Query1'[CompletedDateSK].[Date]That correctly calculated a 90 day average. Then I created 3 measurements and got them all displayed correctly