Previous Date Value Calculation is not working as expected - Immediate response required

Hello There,

We have a Sales Table where the sales date values are stored twice in a month in the format of 2024-06-01, 2024-06-15 for each months.

Now I need to derive a measure to compare the " % of Current Sales vs Previous Sales " by using the logic below:

The logic= (CurrentSales – PreviosSales) / PreviousSales

Expected Output is in Percentage format keeping decimal place as 4.

Example: 0.0056% or 98.0000%

But the measure logic I'm using is not giving the expected result.

There is only Sales date provided as Filter. So If I Filter only by Sales Date, then its returning the result as 0.0000% but If I Add Product Id filter then I can see the expected result as 0.0056%. But as per the requirement only  Sales date filter should be used.

Could you pls. check the measure I provided and help me on deriving the expected output?

Example:

Sales Table:

Filed used in Date Fitler: SalesDate

SelectedDateValue= 2024-06-01 

SalesAmount for Currently Selected date is = 17.71

Now Previous date for 2024-06-01  should be = 2024-05-15

 Sales amount for Previous Sales date (2024-05-15) is =17.81

The logic= (Sales – PreviosSales) / PreviousSales

%of CurrentSales vs Previous Sales = (17.71-17.81)/17.81 =0.0056 %

Expected Result:

Measure Used:

%of CurrentSales vs Previous Sales = Var CurrentDate=MAX( Sales Table'[SalesDate])

Var PreviousDate = CALCULATE(MAX( Sales Table'[SalesDate]),Filter(all('Sales Table'), 'Sales Table'[SalesDAte] < CurrentDate))

Var PreviousSAles=  CALCULATE(sumx('Sales Table', 'Sales Table' [Sales Amount]), 'Sales Table''[SalesDAte]=PreviousDate,ALLSELECTED('Sales Table'))

Var Sales = 'Sales Table' [Sales Amount]),

Var Result =IF (PreviousSAles =0,0,ABS(Sales - PreviousSAles) / PreviousSAles)

Return  Result

amitchandak lbendlin rajendraongole1  I'm tagging few I've seen in the helpers list. But whoever knows the solution for this, pls. help on deriving the solution.