Base On Min Date on Slicer Filter

[shri0025]

Hi Please hep me  i am new on Power 

I have a slicer added on the dashboard. In table visual (data coming from transaction table), I want the sales for the previous date to the minimum of SLicer Date. The previous date will be the date on which the salesamount >0.

Sampledata 

If Selcted 8 July 2019 min date value THAN Show value 3316 Min Date  8 Jun and  data are coming 7 July  and Max date selected 20 Dec Than value SHow 1472

[lbendlin]

For this to work you need a disconnected dates table for your slicer, and then a measure that controls which of the rows in your fact table to show.

See attached.

[shri0025]

Not Solve this Solution 

 i need This way     Please help me   my slicer date  11 July Selected  data show  12 July nut i need  7 july data show  3316 

[lbendlin]

Change your slicer type to "Before"