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.
Hello All,
As shown below, i have got requirement to count the footfall, however in one day there will be multiple entries from the same barcode id.
I need to remove this in power query and keep only 1 data which would be MIN date of that particular day for that particular barcode id.
Please help me
Solved! Go to Solution.
to know how to do this watch my video
https://1drv.ms/v/s!AiUZ0Ws7G26RjEBkV0C3S3OjVGtU?e=uPN2ca
{"tmp", (x)=>Table.Max(x,{"ID",{"Enter time",Order.Descending}})
to know how to do this watch my video
https://1drv.ms/v/s!AiUZ0Ws7G26RjEBkV0C3S3OjVGtU?e=uPN2ca
{"tmp", (x)=>Table.Max(x,{"ID",{"Enter time",Order.Descending}})
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 |
---|---|
98 | |
98 | |
80 | |
76 | |
66 |
User | Count |
---|---|
135 | |
109 | |
104 | |
83 | |
73 |