Forum Discussion

ERIC_A's avatar
ERIC_A
Helper II
3 years ago

Moving Range with Live Dataset Connection

Hi  I have the following table1. This is connected live to the power BI dataset and I want to create a measure to calculate the moving range of Response woid Response 1 10 3 1 4 3 ...
Need Help
Tips and Tricks
lbendlin's avatar
lbendlin
Super User
3 years ago

You cannot do that with a live dataset. Convert to Direct Query with local model.

  • ERIC_A's avatar
    ERIC_A
    Helper II
    3 years ago

    If this cannot be done I wonder how the company PQsystems that sells these MR I chart visuals are able to calculate it ?