Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

reference Previous row using measures.

Hi,

 

I have to implement below SSRS condition in power Bi using Measures only.

Note: We have limitations we can't create any index column here so i need solution using measures only.

Source : Tabular model

Output column =IIF((Previous(Fields!Group_ID.Value) = Fields!Group_ID.Value),Nothing,Fields!Group_ID.Value)

Need Help

5 Replies

  • Mariusz's avatar
    Mariusz
    Community Champion
    7 years ago

    Hi Anonymous 

    Can you create data samples, one with data set that you are working on, and second with the desired outcome.

     
    Best Regards,
    Mariusz

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Group ID | Output

      A101 | A101

      A101 |

      A102 | A102

      A102 |

      A102 |

      A103 | A103

      A101 | A101

      • Mariusz's avatar
        Mariusz
        Community Champion
        7 years ago

        Hi Anonymous 

        I'm very sorry but its very hard to understand you requirement, are you looking to return distinct Values?

        Is your output to be presented in a visual or ist just a table?

        Are you going to use as a part of calculation?

         

        Best Regards,
        Mariusz