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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Sales for this year and last year

Hello All

I am farly new to power BI.

I need to calculate a delta price in Power BI

for this I have a table with the following columns : customer, reference, category, quantity, sates and date of sales

to calculate the delta price DP, i need to calculate YTD sales for this year and last year, this i was ale to do thru total YTD and date table and same for last year

where I struggle is to calculae the total sales for each reference that have been sold this year but also last year  I cxall this measure A2A. ie if a reference was sold this year and last I keep the total sales for both years means : YTD A2A sales =  YTD Sales and LY YTD A2A sales = LY YTD sales 

 

can someone help 

 

Thank you for your support

imbrg

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Yes this is exactly what I wanted for YTD A2A and for LY YTD A2A

what was the measure you used.

what happened to YTD NSP which the averag price for this year : total sales for this year devidefd by total quantities for this year.

 

thank you very muchVVelard, you are so great

 

regards

 

View solution in original post

11 REPLIES 11

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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