locked
ERROR FOR DATE PARAMETER IN SSRS DAX QUERY RRS feed

  • Question

  • Hi All,

    I try to doing SSRS report in tabular Cube and i really do not know about DAX language.When i create year and month parameter in query,i got an error as "Query(1,19) the following syntax error occured during parsing:Invalid token,Line 1,Offset 19,ı."

    My query:

    DEFINE VAR TakvimYıl1 = IF(PATHLENGTH(@TakvimYıl) = 1, IF(@TakvimYıl <> "", @TakvimYıl, BLANK()), IF(PATHITEM(@TakvimYıl, 2) <> "", PATHITEM(@TakvimYıl, 2), BLANK())

    VAR TakvimYıl1ALL = PATHLENGTH(@TakvimYıl) > 1 && PATHITEM(@TakvimYıl, 1, 1) < 1

    please help me:(



    • Edited by kumi987 Tuesday, December 10, 2019 7:27 AM
    Tuesday, December 10, 2019 7:26 AM