Forum Discussion
Previous Year Sales
Hi, I am trying to calculate last year sales using minimum line of dax code as below: Sales Last Year = CALCULATE( [Sales] , PREVIOUSYEAR('Date (Sales Order)'[Order Date] ) ) It gives cor...
bhelou
Responsive Resident
Responsive ResidentDear ,
Check this dax if it fits with you ,
Sales Last Year = CALCULATE(
[Sales],
FILTER(
ALL('Date (Sales Order)'),
'Date (Sales Order)'[Order Date] = MAX('Date (Sales Order)'[Order Date]) - 365
)
)
Change the table Name of the dates accordingly
Please consider accepting this as a solution !! Respect your KUDO !!
I appreciate your recognition and feel proud to have been able to assist you.
