Forum Discussion

alexanderholmes's avatar
alexanderholmes
Frequent Visitor
8 years ago

Creating a table of Recurring Costs in Power Query

Good Afternoon All!   I was hoping someone could help provide the most efficient method of creating a Life Cycle Cost data table based on task frequency and cost data across a defined time period. ...
Need Help
Tips and Tricks
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi alexanderholmes

With your example table (the second picture), I can easily create a chart as you expected.

It is created in the Report View, while "Power Query" refered in your title is in the "Home->edit queries" where can shape and construct data model but can't create visuals.

If you have any question, please feel free to ask me.

 

Best Regards

Maggie

  • alexanderholmes's avatar
    alexanderholmes
    Frequent Visitor
    8 years ago

    Hi Maggie v-juanli-msft,

     

    Thanks for your input!  However, my goal is to create the data table from the Frequency_Days table:

     

     

    Any method to turn the data from the above table to the below table (which I mocked up in Excel) would be greatly appreciated and then I can create the chart in report view.

     

     

    Thanks, Alex