Forum Discussion
Need help for generating raw wise difference from column using DAX or power query
Hi again
Please try ask the right question first time, because it is a bit annoying having to answer twice 😀😀😀
Click here to download a solution ftom one drive
This method will work for 25 machines or more
Please will you now click [thumbs up] and [accept solutoon button]. Thank you !
How it works ...
For the date correctly
Select the Date and Shift columns, then Transform> Unpiciot>Unpivot other columns
Sort by Machine, Date and Shift
Add an index column from 0 incrementing by 1
Get the machine and reading for the previous row
Change reading to numeric data types
and add a conditional columnRenove the unneeded columns and change the usage ro a numeric data type
Draw your graph
In the above example I assumed that shift #2 comes after shift #1, but this creates negative usage on the 27/05/2025
In this method I have sorted by machine and reading number
Click here to download from Onedrive
I dont know what sequence you require, but I trust I have taught you the method well enough now
and that you can change the sort sequence as you require
Hi speedramps ,
Thank you so much for the support and guidance!
Sorry, for the inconvenience caused and delayed in response as I was not available for some days due to some emergency medical situation...
Thanks a lot!👍
