Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Community,
Looking for help for this problem. I have one table containing Visitor ID, Date/Time and Sensor.
I want to calculate which sensor the Visitor ID moved to next, so I can do a flow diagram (highlighted in yellow below)
Any ideas?
Solved! Go to Solution.
HI @Anonymous
Try this calculated Column
Sensor to = VAR NextTime = CALCULATE ( MIN ( Table1[Time] ), FILTER ( ALLEXCEPT ( Table1, Table1[Date], Table1[Visitor_ID] ), Table1[Time] > EARLIER ( Table1[Time] ) ) ) RETURN CALCULATE ( FIRSTNONBLANK ( Table1[Sensor], 1 ), FILTER ( ALLEXCEPT ( Table1, Table1[Date], Table1[Visitor_ID] ), Table1[Time] = NextTime ) )
HI @Anonymous
Try this calculated Column
Sensor to = VAR NextTime = CALCULATE ( MIN ( Table1[Time] ), FILTER ( ALLEXCEPT ( Table1, Table1[Date], Table1[Visitor_ID] ), Table1[Time] > EARLIER ( Table1[Time] ) ) ) RETURN CALCULATE ( FIRSTNONBLANK ( Table1[Sensor], 1 ), FILTER ( ALLEXCEPT ( Table1, Table1[Date], Table1[Visitor_ID] ), Table1[Time] = NextTime ) )
Hi @Anonymous,
I'm glad to hear that you have resolved your issue. Please kindly mark the corresponding reply. It will help others with relevant issue find the answer more easily.
Thanks,
Xi Jin.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |