Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |