Forum Discussion

mollino's avatar
mollino
New Member
2 years ago
Solved

Creating a report starting from two tables with different layouts

Hello, I'm new to Power BI, I'll try to be as clear as I can.  Let's say I have a certain amount of WBSs with a cost associated to them. I want to create a report which compares the planned cost and...
Need Help
  • NaveenGandhi's avatar
    NaveenGandhi
    2 years ago

    To address the 1st part, Unless the first 3 columns[WBS L1, WBS L2, WBS L3] stays constant, you can use the "unpivot other columns" options in PowerQuery to do the job for you.


    As far as the dates, Whatever the date range is from, You can use Power Query to make it start of everymonth or StartofMonth Dax function to create a column.


    If you still have doubts or questions, Can you provide a Sample file or image on how exactly current structure is?

    Thanks,
    NG
     If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!

NaveenGandhi's avatar
NaveenGandhi
Icon for Memorable Member rankMemorable Member
2 years ago

To address the 1st part, Unless the first 3 columns[WBS L1, WBS L2, WBS L3] stays constant, you can use the "unpivot other columns" options in PowerQuery to do the job for you.


As far as the dates, Whatever the date range is from, You can use Power Query to make it start of everymonth or StartofMonth Dax function to create a column.


If you still have doubts or questions, Can you provide a Sample file or image on how exactly current structure is?

Thanks,
NG
 If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!