DAX table it's not working anymore

[Anonymous]

I have used a table created with DAX in the past to use it as a date filter, and it worked perfectly. Now i want to use it again but it's not working anymore. It comes out with a syntax error. 

MTD/QTD/YTD =

VAR TodayDate = TODAY()

VAR YearStart = CALCULATE(STARTOFYEAR(Query1[Fecha]), YEAR(Query1[Fecha]) = YEAR(TodayDate))

VAR QuarterStart = CALCULATE(STARTOFQUARTER(Query1[Fecha]), YEAR(Query1[Fecha]) = YEAR(TodayDate), QUARTER(Query1[Fecha]) = QUARTER(TodayDate))

VAR MonthStart = CALCULATE(STARTOFMONTH(Query1[Fecha]), YEAR(Query1[Fecha]) = YEAR(TodayDate), MONTH(TodayDate) = MONTH(TodayDate))

VAR Result =

UNION(

ADDCOLUMNS(

CALENDAR(YearStart, TodayDate),

"Selection", "YTD"

),

ADDCOLUMNS(

CALENDAR(QuarterStart, TodayDate),

"Selection", "QTD"

),

ADDCOLUMNS(

CALENDAR(MonthStart, TodayDate),

"Selection", "MTD"

)

)

RETURN

Result))

Please help me to figure this out

[Anonymous]

Now is showing other error 

The True/False expression does not specify a column. Each True/False expressions used as a table filter expression must refer to exactly one column.

[mahoneypat · Accepted solution]

There was a typo in the MonthStart variable.  Please try this instead.  However, this will generate a table where many dates are duplicated which measn you won't be able to "mark as date table" and/or use Time Intelligence functions.  And it will require M:M relationships with your other tables.  I would encourage you to get this same functionality using Calculation Groups (one Calculation Item for each of MTD, QTD, and YTD).

MTD/QTD/YTD =
VAR TodayDate =
    TODAY ()
VAR YearStart =
    CALCULATE (
        STARTOFYEAR ( Query1[Fecha] ),
        YEAR ( Query1[Fecha] ) = YEAR ( TodayDate )
    )
VAR QuarterStart =
    CALCULATE (
        STARTOFQUARTER ( Query1[Fecha] ),
        YEAR ( Query1[Fecha] ) = YEAR ( TodayDate ),
        QUARTER ( Query1[Fecha] ) = QUARTER ( TodayDate )
    )
VAR MonthStart =
    CALCULATE (
        STARTOFMONTH ( Query1[Fecha] ),
        YEAR ( Query1[Fecha] ) = YEAR ( TodayDate ),
        MONTH ( Query1[Fecha] ) = MONTH ( TodayDate )
    )
VAR Result =
    UNION (
        ADDCOLUMNS ( CALENDAR ( YearStart, TodayDate ), "Selection", "YTD" ),
        ADDCOLUMNS ( CALENDAR ( QuarterStart, TodayDate ), "Selection", "QTD" ),
        ADDCOLUMNS ( CALENDAR ( MonthStart, TodayDate ), "Selection", "MTD" )
    )
RETURN
    Result

Pat

[speedramps]

Hi juank_maxxom

Please consider this solution and leave Kudos ..

Try remove the )) at the end  .... that will cause a syntax error

RETURN

Result))