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.
Hi,
I want to track when a new Variant is being registered/produced in my dataset in the column changeover
My table looks similar to this
ID | VARIANT | Changeover |
1 | A | |
2 | A | 1 |
3 | A | 1 |
4 | B | 0 |
5 | B | 1 |
6 | B | 1 |
7 | C | 0 |
Basically everytime that the previous row is not matching the next row, post changeover or 1 or 0 (W/E)
Blue equals desired state and is what i want to achieve
Hope someone can help
BR
Kristian
Solved! Go to Solution.
I solved it like this
@Anonymous , Create a new column like
new column =
var _max= Maxx(filter(Table, [ID] = earlier([ID])-1 ), [VARIANT])
return
if(_max =[VARIANT] ,1,0)
I solved it like this
User | Count |
---|---|
88 | |
72 | |
69 | |
65 | |
57 |
User | Count |
---|---|
93 | |
93 | |
91 | |
76 | |
69 |