Forum Discussion
Helper IIssues 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 not be Blank value.
Guys, Thanks
The problem was coming from calendar table as the max date was in last year.
Thanks
9 Replies
anwargabrThanks for your answer, actually it's a mesure to create a table, so it can't be card
- BA_Pete
Super User
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
- v-xulin-mstf
Community Support
- anwargabr
Guys, Thanks
The problem was coming from calendar table as the max date was in last year.
Thanks
Can you explain how your solved this issue? I'm having the exact same one and can't find the solution oyu mentioned here
