Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have a customer table whose ID must be unique, but it happens that for the same customer the ID changes I want to detect the new ID and underline it in red
customer | id |
chriss | 770 |
Jean | 660 |
luck | 550 |
chriss | 770 |
chriss | 112 |
Solved! Go to Solution.
@sidyahmed_pbix , You need an index column for that.Add that in Power BI
New flag column =
Var _id = maxx(filter(Table, [customer] = earlier([customer]) && [index] < earlier([index]) && [id] <> earlier([id]) ), [Id])
return
if (not(isblank(_id)),1,0)
@sidyahmed_pbix , You need an index column for that.Add that in Power BI
New flag column =
Var _id = maxx(filter(Table, [customer] = earlier([customer]) && [index] < earlier([index]) && [id] <> earlier([id]) ), [Id])
return
if (not(isblank(_id)),1,0)
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
85 | |
84 | |
67 | |
63 | |
62 |
User | Count |
---|---|
208 | |
121 | |
112 | |
79 | |
71 |