Show Last day sales in Measure and it should not change if I click on any other day from my table

09-24-2022 05:16 AM

Not applicable

1066 Views

Hi All,

I want to show last day sales value in Card but whenever I select any day from table matric eg. 28 Day it show me value for 27 day.

I want 6442 valaue as my last day(29 ) sales value in Card. And I dont want to change my card value in any case. it should be fix

Note : My last day is 30th but I don't have any value in 30day. So I am doing max day Minus(-) 1 in my dax.

Below Dax function I am using

Last date Sales = Var A = MAX('Calendar'[Transaction_Date])

Var B = CALCULATE(sum('Sales by Store'[Sales]), 'Calendar'[Transaction_Date]=a-1

)

Return