Forum Discussion

anwargabr's avatar
anwargabr
Helper I
5 years ago
Solved

Issues with Calendar DAX

Dears ,   I tried to creat Time Intelligence Slicer, the same one in theis video https://youtu.be/AdLDYohLeJc But I stuck with this message. The start date or end date in Calendar function can...
Need Help
  • anwargabr's avatar
    anwargabr
    5 years ago

    Guys, Thanks

     

    The problem was coming from calendar table as the max date was in last year.

    Thanks

BA_Pete's avatar
BA_Pete
Super User
5 years ago

Hi anwargabr ,

 

Have you tried putting this measure into a card and changing the RETURNed variable to each of your declared variables in turn to see which, if any, return blank?

 

Pete

  • anwargabr's avatar
    anwargabr
    Helper I
    5 years ago

    Thanks for your answer, actually it's a mesure to create a table, so it can't be card

    • BA_Pete's avatar
      BA_Pete
      Super User
      5 years ago

      anwargabr ,

       

      It looks like all of your declared variables (todaydate, YearStart etc.) all evaluate to scalar values. Therefore, you can display each of these in a card if you change the variable after your RETURN statement to each of these variables in turn, as suggested.

       

      Change this "result" variable to "todaydate" and put the measure in a card. See if it returns blank. Then change it to "YearStart" and so on. You will then be able to identify if one of your variables is causing the problem within your "Result" variable calculation.

       

      Pete

      • anwargabr's avatar
        anwargabr
        Helper I
        5 years ago

        I chnaged to a measure and followed your advise, Yearstart, Monthstart and Quarterstart gives blank, only todaydate is give me value.