Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be 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

Reply
abc_777
Solution Specialist
Solution Specialist

hi

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

 

2019-2020- FY 2020.jpg

 

 

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

 

2020-2021- FY2021.jpg

 

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

 

 

2 ACCEPTED SOLUTIONS

Total Quantity in Piece (Measure) = CALCULATE
(SUMX
    ('bm_retail_t sale', ('bm_retail_t sale'[SQTY]  ----------------> sale quantity column
        -'bm_retail_t sale'[RQTY]))) --------------> return quantity column
 
 ======================================================
 
Quantity Last Year =
CALCULATE(
    [Total Quantity in Piece (Measure)],
    PARALLELPERIOD(
        BMCalendar[Date],
        -1,
        YEAR
    )
)
 
if i could share it would easy for me to destribe but this is full of cmpany data as you seen my previous scren shot. i am sorry. but really need your help to do this
 
thanks
 
 

View solution in original post

abc_777
Solution Specialist
Solution Specialist

no way to subtract two measure in two different row?

View solution in original post

4 REPLIES 4
abc_777
Solution Specialist
Solution Specialist

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

 

abc_777_1-1663691557123.png

 

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

 

 

abc_777
Solution Specialist
Solution Specialist

no way to subtract two measure in two different row?

v-yiruan-msft
Community Support
Community Support

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

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Total Quantity in Piece (Measure) = CALCULATE
(SUMX
    ('bm_retail_t sale', ('bm_retail_t sale'[SQTY]  ----------------> sale quantity column
        -'bm_retail_t sale'[RQTY]))) --------------> return quantity column
 
 ======================================================
 
Quantity Last Year =
CALCULATE(
    [Total Quantity in Piece (Measure)],
    PARALLELPERIOD(
        BMCalendar[Date],
        -1,
        YEAR
    )
)
 
if i could share it would easy for me to destribe but this is full of cmpany data as you seen my previous scren shot. i am sorry. but really need your help to do this
 
thanks
 
 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.