Forum Discussion

Nicks612's avatar
Nicks612
Helper I
1 year ago
Solved

Need help for generating raw wise difference from column using DAX or power query

Hello everyone,   Can anyone help me with the below problem?   I have attached table named "Raw Data" which contains the Date, Shift, Machine A & Machine B columns. Machine A & Machine B columns ...
Need Help
  • speedramps's avatar
    speedramps
    1 year ago

    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

    Click here 

     

    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 column

     

     

    Renove the unneeded columns and change the usage ro a numeric data type

     

     

    Draw your graph

     

     

speedramps's avatar
speedramps
Super User
1 year ago

There are lots of ways to solve this problem but try this ...

 

Click here to download a solution from Onedrive

Click here 

 

How it works ...

 

Change bakue data types to numeric
Change the date to a proper date.

Sort by date and shift.

Add Index colum

Use the index to get the previous meter reading for A.
Then use the index to get the previous meter reading for B.
 

Calculate the usage

Draw the graph

 

 

Please click thumbs up because I have tried to help.

 

Then click [accept solution] if it works.

 

Many thanks !