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