Forum Discussion

Solution Specialist

3 years ago

Solved

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 20...

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?

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