Forum Discussion

DrHematite's avatar
DrHematite
Frequent Visitor
7 years ago
Solved

Chart on multiple dates

Hi everyone, I have two tables that are formatted as follows: First one is for planned components:                                        Component Qty Date Required A 1 1/12/2019 B...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi DrHematite 

    You may use 'Unpivot columns' for 1st change,2nd Change...columns in query editor.Then you may link the date table with the two tables to get the visual.

    Regards,

v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

Hi DrHematite 

You may use 'Unpivot columns' for 1st change,2nd Change...columns in query editor.Then you may link the date table with the two tables to get the visual.

Regards,

  • DrHematite's avatar
    DrHematite
    Frequent Visitor
    7 years ago

    Hi Cherie,

     

    That's perfect, thank you.