Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Difference between two indexed rows as measure

Hi Team, 

 

shed the light on this please:

 

what i need to do is calculating trade ups, namely the difference between Current price QF row 23 - 22 and so on.

 

so basically tariff level is the index .

 

thank youu

Need Help
Tips and Tricks
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Anonymous

     

    Try with following

     

    trade ups MEASURE =
VAR myindex =
    SELECTEDVALUE ( Table1[Tariff Level] )
RETURN
    [Current_Price_QF]
        - CALCULATE (
            [Current_Price_QF],
            FILTER ( ALL ( Table1 ), Table1[Tariff Level] = myindex - 1 )
        )

3 Replies

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    8 years ago

    Anonymous

     

    Try this MEASURE

     

    trade ups MEASURE =
VAR myindex =
    SELECTEDVALUE ( Table1[Tariff Level] )
RETURN
    SUM ( Table1[Current_Price_QF] )
        - CALCULATE (
            SUM ( Table1[Current_Price_QF] ),
            Table1[Tariff Level]
                = myindex - 1
        )
    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi Muhammad,

       

      just one thing: Current Price QF is a measure so doesn't really work that way. 

      I tried to sobstitute the measure with the source data but doesn't really seem ok. 

       

      Any adjustment?

      • Zubair_Muhammad's avatar
        Zubair_Muhammad
        Community Champion
        8 years ago

        Anonymous

         

        Try with following

         

        trade ups MEASURE =
VAR myindex =
    SELECTEDVALUE ( Table1[Tariff Level] )
RETURN
    [Current_Price_QF]
        - CALCULATE (
            [Current_Price_QF],
            FILTER ( ALL ( Table1 ), Table1[Tariff Level] = myindex - 1 )
        )