I need a help with the case below:
How to write it in Dax or Powerquery a code like this below:
Expected Result =
VAR V_ID = 1RETURN
if('Table'[OverflowAlarm] = 1 && 'Table'[Previus row] = 0, V_ID, if('Table'[OverflowAlarm] = 0 && 'Table'[Previus row] = 1, V_ID = V_ID +1 ,
if ('Table'[OverflowAlarm] = 1 && 'Table'[Previus row] = 1, 'Table'[OverflowAlarm],0)))
I have a table like that:
And that is the result that I need:
Any help is welcome!
You may take a look at the post below.
@v-chuncz-msft wrote:@jgoncal , You may take a look at the post below.https://community.powerbi.com/t5/Desktop/Finding-the-previos-occurrence-within-same-table-based-on-o...
Thanks for your response.
I am not a Power Bi expert, I've been working only few weeks with it. But, I couldn't see it working for me. And the function earlier doesn't work well... too many rows in the table, it runs forever... Any other solution?
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!