Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Issue with Dax Code to create custom Slicer getting error

This is the code: I am getting the following error "The start date or end date in Calendar function can not be Blank value" I followed the directions in an example and I cannot figure out what I am...
"DAX help"
  • ValtteriN's avatar
    ValtteriN
    2 years ago

    Hi,

     

    Without seeing The data my speculation is that  your Column: SL_Data[Month Year]. Is not date/time Column. Because of this STARTOFYEAR returns blank. You yhen refer to this variable on your CALENDAR function resulting on The error.

     

    I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

    My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

ValtteriN's avatar
ValtteriN
Community Champion
2 years ago

Hi,

 

Without seeing The data my speculation is that  your Column: SL_Data[Month Year]. Is not date/time Column. Because of this STARTOFYEAR returns blank. You yhen refer to this variable on your CALENDAR function resulting on The error.

 

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/