topic Re: Base On Min Date on Slicer Filter in DAX Commands and Tips

Base On Min Date on Slicer Filter

shri0025 — Fri, 09 Jun 2023 12:52:32 GMT

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

Re: Base On Min Date on Slicer Filter

lbendlin — Mon, 12 Jun 2023 02:09:29 GMT

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.

Re: Base On Min Date on Slicer Filter

shri0025 — Mon, 12 Jun 2023 05:46:24 GMT

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

Re: Base On Min Date on Slicer Filter

lbendlin — Mon, 12 Jun 2023 21:51:13 GMT

Change your slicer type to "Before"