09-24-2022 05:16 AM
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
@User2 @Super127 @DAXY DAX help @Experteam