Forum Discussion

IDAX's avatar
IDAX
Frequent Visitor
1 year ago

dynamic diff calculation row in matrix

Dear Power BI Gurus !   I'm struggling for some time already with creating of dynamic calculation which would return difference between selected rows in matrix. Here's a sample of raw data: ...
Need Help
lbendlin's avatar
lbendlin
Super User
1 year ago

What do you need the slicer for?

  • IDAX's avatar
    IDAX
    Frequent Visitor
    1 year ago

    The slicer will be selecting Forecast ID

    • lbendlin's avatar
      lbendlin
      Super User
      1 year ago

      But then you are showing all forecast IDs in the visual.  There's no need for the slicer?

      • IDAX's avatar
        IDAX
        Frequent Visitor
        1 year ago

        I'm sorry for not being precise enough. There will be more than 2 Forecast IDs. So I need to have a possibility to dynamically see what are the Actuas and two other Forecast IDs (latest one vs. previous one).