March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi,
in one screen shot when select slicer FY20
total quantity in Piece (measure) column for year 2019 is 1,744,518 KG (Current Data)
total quantity in Piece (measure) column for year 2020 is 1,608,268 KG (Current Data)
quantity last year shows me total quantity of 2019 and 2020
another screen shot when select FY21
total quantity in Piece (measure) column for year 2020 is 1,450,762 KG (Current Data)
total quantity in Piece (measure) column for year 2021 is 1,802,746 KG (Current Data)
quantity last year shows me total quantity of 2020 and 2021
but what i want is when i select slicer FY21 is as follows,
Quanityt 6 month (financial year data) Current (total quantity in Piece (measure)
2019 1,744,518 KG 2020 1,450,762 KG
2020 1,450,762 KG 2021 1,802,746 KG
again when I select FY22 data would be as follows,
Quanityt 6 month (financial year data) Current (total quantity in Piece (measure)
2020 1,450,762 KG 2021 1,802,746 KG
2021 1,802,746 KG 2022 data for 2022 KG
i hope its understandable
please help
thanks
Solved! Go to Solution.
no way to subtract two measure in two different row?
hi
my
FY21 sale quantity is 3,253,508 and target is 3,253,508 * 1.20 = 3,904,210 (which is for 2021 July to 2022 June Target)
and
FY22 sale quantity is 4,271,791 and target is 4,271,791 * 1.20 = 5,126,149 (which is for 2022 July to 2023 June Target)
can some one tell me how can i do subtract
3,904,210 - 4,271,791 = -367,581
here total quantity in piece (measure) is just sale quantity measure
and
Targer quantity company (Yearly) is also a measure
does anyone has any other easy way or more acceptable way to do this calculation
thanks
no way to subtract two measure in two different row?
Hi @abc_777 ,
Could you please provide the formula of measure [quantity last year] and [Total Quantity in Piece (measure)]? It is better if you can provide a simiplified pbix file in order to make troubleshooting and give you a suitable solution quickly? Thank you.
Best Regards
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
90 | |
86 | |
83 | |
72 | |
49 |
User | Count |
---|---|
167 | |
149 | |
98 | |
73 | |
57 |