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

qqqqqwwwweeerrr's avatar
qqqqqwwwweeerrr
Icon for Solution Sage rankSolution Sage
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

     

    Thanks you for the try , I'm getting the following error in the visual when loading your DAX code