Forum Discussion
Solved
Sorting And Comparing Row in Power BI
Hi Power BI Community, Need help in creating DAX code or power query code to create additional column (Run # and Final Status) in below File Run Dataset Table Initial column detail as per bel...
NSBS , New columns
Run = rankx(filter(Table, [File Name] = earlier([Filename]) ), [Loaded Date/Time],,asc,dense)
Final Status = minx(filter(Table, [Run] = earlier([Run]) ) ,[Status] )
NSBS , New columns
Run = rankx(filter(Table, [File Name] = earlier([Filename]) ), [Loaded Date/Time],,asc,dense)
Final Status = minx(filter(Table, [Run] = earlier([Run]) ) ,[Status] )