Subtract value of one table from another in PowerBI

1
votes

I have the following data

Date    Band    Colour  Amount
02/01/2020  0-50    Red    20
01/01/2020  51-100  Blue    18
03/01/2020  51-100  Red     14
01/01/2020  51-100  Red     18
02/01/2020  51-100  Red     16
02/01/2020  51-100  Blue    14
01/01/2020  0-50    Red     12
03/01/2020  51-100  Blue    20
01/01/2020  51-100  Red     12
02/01/2020  0-50    Blue    11
02/01/2020  0-50    Red     13
01/01/2020  0-50    Red     10
02/01/2020  51-100  Blue    17
01/01/2020  51-100  Blue    17

I want to produce two table and filter by date. the first table create colour by band and sum the total. same as the second table. the challenge is to find the difference between table one and table two base on filtered date

the table below show all report without filtering enter image description here

when I filter table 1 to 01/01/2020and table 2 to 02/01/2020 my expected output will be enter image description here

1
powerbidaxpowerquery
What issue you are facing? – mkRabbani
@mkRabbani How i can achieve it in power BI – JonWay
You can use Metrix visual to achieve this easily. I tried with your sample data and found values showing as your expectation. – mkRabbani

1 Answers

1
votes

Please check the attached .pbix file for your reference. It is difficult to explain the whole process and as a result I have attached the report file here. Check these following things from the report-

  1. Two separate Date table for two different slicer
  2. Created three measure
  3. Interaction between Slicer and Metrix visuals.

Get the Report File Here