Forum Discussion

barakm's avatar
barakm
Frequent Visitor
2 years ago
Solved

last date not shown correctly

Hello Dear Team, Got an issue with displaying the last date I have a table with startTime endTime and WeekRange  startTime        endTime 2024-07-02    2024-07-09 2024-07-09    2024-07-16 2024-...
"Date"
DAX Max Date within date range
  • qqqqqwwwweeerrr's avatar
    qqqqqwwwweeerrr
    2 years ago
    Max Range =
    VAR MaxStartDate =
        MAXX(ALL('Table'), 'Table'[startTime])
    VAR MaxEndDate =
        MAXX(
            FILTER(
                ALL('Table'),
                'Table'[startTime] = MaxStartDate
            ),
            'Table'[endTime]
        )
    VAR RangeValue =
        CALCULATE(
            VALUES('Table'[week_range]),
            'Table'[startTime] = MaxStartDate &&
            'Table'[endTime] = MaxEndDate
        )
    RETURN
        IF(
            ISBLANK(RangeValue),
            BLANK(),
            RangeValue
        )
     

    I am getting this can you please check, if this works

     

    Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
    Check for more intersing solution here: www.youtube.com/@Howtosolveprobem

    Regards

barakm's avatar
barakm
Frequent Visitor
2 years ago

My bad, it works , thanks a lot