none
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:(

    Tuesday, December 10, 2019 8:01 AM

All replies

  • 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()))

    seems missed one ")" in the end.

    Lukas


    MSDN Community Support Please remember to click Mark as Answer; the responses that resolved your issue, and to click Unmark as Answer if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Wednesday, December 11, 2019 3:33 AM