Using measures for Date column rather than Index col for row context

Jarvis,

This is the closest I can get to coming up with a solution with the information you have provided. Let me know if this works for you. If not, you need to provide an Excel sheet with the data that is in the model with the expected result. Here is the link that I tried to get as close as I could to replicating how they solved the EMA:

EDNA- Solution with EMA.pbix (722.9 KB)

Thanks
Jarrett

1 Like