Forum Discussion
Dealing with data gaps while using moving averages with rolling
Good evening. I'm trying to calculate moving averages on geophysical data, a bunch of drillholes, where the first column is the hole name, the second is depth and third is the specific weight. M...
mahoneypat
Microsoft Employee
Microsoft EmployeeNot sure if there is a simple fix for this. Initial thought is to add a column (in DAX or M) that puts the data into dynamic groups/categories (e.g., breaking on where there are big gaps in x axis data). You could then use that column as a legend. They would start different color but you could change the colors to match I think.
If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat