Forum Discussion

randyvdr's avatar
randyvdr
Frequent Visitor
3 years ago
Solved

TotalYTD Days - Calendar table

Hello community,   I am trying to return the number of cumulative days of the year until the last date data available, I am trying something like this but does not work: --------------------------...
  • johnt75's avatar
    johnt75
    3 years ago

    Try

    Year count Days =
VAR MaxDate =
    MAX ( 'data'[Date] )
VAR DaysWithData =
    COUNTROWS (
        FILTER (
            DATESYTD ( 'Calendar Table'[Date] ),
            'Calendar Table'[Date] <= MaxDate
        )
    )
RETURN
    DaysWithData
johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

Try

Year count Days =
VAR MaxDate =
    MAX ( 'data'[Date] )
VAR DaysWithData =
    COUNTROWS (
        FILTER (
            DATESYTD ( 'Calendar Table'[Date] ),
            'Calendar Table'[Date] <= MaxDate
        )
    )
RETURN
    DaysWithData