Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

DAX: Average over data gaps

Hi! I'm creating a measure for average machine capacities and wonder if there is an easy way to deal with gaps in data. Let's say there are 3 available machines (A, B, C) and that I have these facts...
  • Eric_Zhang's avatar
    Eric_Zhang
    9 years ago

    Anonymous

     

    I  think it all depends on the data model in your case. Check a simple demo below.

     

     

Eric_Zhang's avatar
Eric_Zhang
Microsoft Employee
9 years ago

Anonymous

 

I  think it all depends on the data model in your case. Check a simple demo below.