Forum Discussion
DAX Function to create sales difference between two consecutive dates
Hello Everyone, I am stuck in creating DAX function to create sales difference between two consecutive dates. I have a data in the following table shown below - As_of_Date Sales 07-05-20...
Hi SC30GSWNBA you can create 2 measures :
PreviousDateSales =
VAR CurrentDate = MAX('Sales table'[As_of_Date])
VAR PreviousDate = CALCULATE(MAX('Sales table'[As_of_Date]), 'Sales table'[As_of_Date] < CurrentDate)
RETURN
CALCULATE(SUM('Sales table'[Sales]), 'Sales table'[As_of_Date] = PreviousDate)
For Delta :
Delta = [sales_]-[PreviousDateSales]
Result :
PBIX is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
The PreviousDate VAR is returning me 31st Dec 2024. May be that's the reason why it is not working.
Hi SC30GSWNBA i see that all results are correct....
Did you download the pbix to follow thr steps?
If yes please show what is wrong
Yes, I downloaded your file. I am connected to a database and when I apply MAX(Sales Data[Date]), it gives me 31st Dec 2024 as the output rather than the latest date. Not sure why that is happening.
