Forum Discussion

ChubbChubb's avatar
ChubbChubb
Helper I
2 years ago
Solved

Previous Data Collection

I'm trying to get the previous report data to appear next to current report data but can't get it to work.   There is a filter on the page to pick a particular data point and I want to show if it h...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi ChubbChubb ,

     

    A separate filter table needs to be created for the Period Sequential Number field. Then modify the formula as above, refer below:

    Slicer = VALUES('Table'[Period Sequential Number])

    Previous % 9-4 = 
VAR CurrentDC =
    SELECTEDVALUE (Slicer[Period Sequential Number])
VAR PreviousDC = CurrentDC - 1
RETURN
    CALCULATE (
        MAX('Table'[% 9-4]),
        'Table'[Period Sequential Number] = PreviousDC
    )

    Best Regards,
    Adamk Kong

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Previous Data Collection.pbix29 KB
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi ChubbChubb ,

 

A separate filter table needs to be created for the Period Sequential Number field. Then modify the formula as above, refer below:

Slicer = VALUES('Table'[Period Sequential Number])

Previous % 9-4 = 
VAR CurrentDC =
    SELECTEDVALUE (Slicer[Period Sequential Number])
VAR PreviousDC = CurrentDC - 1
RETURN
    CALCULATE (
        MAX('Table'[% 9-4]),
        'Table'[Period Sequential Number] = PreviousDC
    )

Best Regards,
Adamk Kong

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Previous Data Collection.pbix29 KB