Forum Discussion

powerbricco's avatar
powerbricco
Icon for Advocate I rankAdvocate I
1 year ago
Solved

PQ Transformation

Dear All, I have the following table in PowerQuery: Date Value 15/01/2025 null 14/01/2025 null 13/01/2025 null 12/01/2025 null 11/01/2025 null 10/01/2025 null 09/01/2...
Need Help
  • speedramps's avatar
    speedramps
    1 year ago

    I am not a AI response.

    Please try this method which i have tested ...
    Reference yourdata to create a new table called "dates"
    Remove any rows from "dates" that have nulls

    Then add a index column

     

     

     

    Then do the same kind of thingsto create a "values" tables

     

    So you now have 2 tables

     

    Merge the tables using the index to create another table

     

    Expand the table

     

     

     Congratultaions ... you have your answer

     

     

     

    Merge the tables



     

speedramps's avatar
speedramps
Icon for Super User rankSuper User
1 year ago

I am not a AI response.

Please try this method which i have tested ...
Reference yourdata to create a new table called "dates"
Remove any rows from "dates" that have nulls

Then add a index column

 

 

 

Then do the same kind of thingsto create a "values" tables

 

So you now have 2 tables

 

Merge the tables using the index to create another table

 

Expand the table

 

 

 Congratultaions ... you have your answer

 

 

 

Merge the tables