how to show the difference between the amounts of two quarters which I select from slicer
Hello team, I am new to Power BI DAX, and I wants to show the differerence between the amount of 1 quarter with another. If suppose I select Q1 2021 and Q2 2021 from my Quarter slicer then results should come like below- Product Description Q1 2021 ($000) Q2 2021 ($000) $ Change ($000) % Change A $67,957 $67,726 ($231) 0% B $27,716 $26,050 ($1,666) -6% C $7,692 $9,275 $1,583 21% D $6,974 $7,863 $888 13% Below is my sample data - Product Name QuarterYear INVOICEDATE ChargeAmount A Q1 2021 2/28/2021 7126816.01 A Q2 2021 5/31/2021 6054198.33 B Q2 2021 4/30/2021 5879113.68 B Q1 2021 1/31/2021 5293888.03 C Q2 2021 6/30/2021 4904149.4 A Q1 2021 3/31/2021 4372781.54 B Q1 2021 1/5/2021 3754678.19 D Q1 2021 3/29/2021 3577814.64 E Q2 2021 6/29/2021 3286894.5 Any help is much appreciated...!