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

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

Need Help

abc_777
3 years ago

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
abc_777
3 years ago
no way to subtract two measure in two different row?

4 Replies

Anonymous
Not applicable
3 years ago
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
- abc_777
  Solution Specialist
  3 years ago
  
  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
abc_777
Solution Specialist
3 years ago
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
- abc_777
  Solution Specialist
  3 years ago
  no way to subtract two measure in two different row?

Forum Discussion

hi