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.
I am dealing with data that deals with wood logs. Production is being tracked by incremented data. For example, between lines 9 and 10 you can see the data going from 536876724 to 53687644. This means that in that 30 seconds, 20 more peices of wood were produced or sent through that station in the mill. What I need is to find a way to bring this into Power Bi. Does anyone know a formula or a way to get production based off of this incremented data? Additionally, I will need to have selections for different intervals of time. I want to be able to select intervals and have power bi group the data accordingly. I'm completely lost on how to make this work or what formula would do the trick. Please help!
maybe you can try this
Column =
VAR _last=maxx(FILTER('Table (2)','Table (2)'[date]<EARLIER('Table (2)'[date])),'Table (2)'[date])
return 'Table (2)'[data]-maxx(FILTER('Table (2)','Table (2)'[date]=_last),'Table (2)'[data])
Proud to be a Super User!
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 |
---|---|
110 | |
109 | |
88 | |
76 | |
66 |
User | Count |
---|---|
126 | |
112 | |
99 | |
82 | |
73 |