Forum Discussion

istvan_nagyracz's avatar
istvan_nagyracz
Regular Visitor
5 years ago
Solved

Create a filtered table based on a date filter

Dear Everybody,   I have a sales pipeline table in the structure below. Date Deal name Deal stage 2021-03-01 apple First 2021-03-13 apple Second 2021-03-14 apple Third 2021-...
Date
DAX
Filter
  • CNENFRNL's avatar
    CNENFRNL
    5 years ago

    istvan_nagyracz , a separate date table is enough for a solution to your question,

    _ = 
VAR __dt = MAX ( Deal[Input date] )
RETURN
    IF (
        __dt >= MAX ( Dates[Date] )
            && __dt = CALCULATE ( MAX ( Deal[Input date] ), ALLEXCEPT ( Deal, Deal[Deal Name] ) ),
        ""
    )

CNENFRNL's avatar
CNENFRNL
Icon for Community Champion rankCommunity Champion
5 years ago

istvan_nagyracz , a separate date table is enough for a solution to your question,

_ = 
VAR __dt = MAX ( Deal[Input date] )
RETURN
    IF (
        __dt >= MAX ( Dates[Date] )
            && __dt = CALCULATE ( MAX ( Deal[Input date] ), ALLEXCEPT ( Deal, Deal[Deal Name] ) ),
        ""
    )

istvan_nagyracz's avatar
istvan_nagyracz
Regular Visitor
5 years ago

Thanks, this is almost a good solution. I changed it so much that I linked the date and deal tables and removed the condition __dt> = MAX (Dates [Date]) from the measure formula.

 

I am grateful for your help, have a nice day,
Istvan