Forum Discussion

Pursuit01's avatar
Pursuit01
New Member
3 years ago
Solved

Comparison Chart

Hi,   I have 2 summary tables that I imported to power bi desktop, below is an example of the data: TABLE A: ID ALLOC DATE AMOUNT BILLED 1 1/31/2021 15.50 2 2/25/2021 10.50 3 3...
  • vanessafvg's avatar
    3 years ago

    what are you comparing against?

     

    amount billed by year, month, day, something else?

     

    the best way to model this date is to add a date table, and link both tables fromthe date table.  then you can use the date information in the date table to slicer your data and compare values between the table.