Issues with Calendar DAX

[anwargabr]

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.

[anwargabr · Accepted solution]

Guys, Thanks

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

Thanks

[powerbinewguy]

Can you explain how your solved this issue? I'm having the exact same one and can't find the solution oyu mentioned here

[v-xulin-mstf]

Hi @anwargabr,

Sorry, i can not see your share.

Is your issue solved?

Best Regards,

Link

[BA_Pete]

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]

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

[BA_Pete]

@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]

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

[BA_Pete]

@anwargabr 

Ok. I think there may be a few issues at play here.

1) the STARTOFYEAR() function outputs a table, not a scalar value

2) I'm unclear whether your [Month Year] field contains date values

3) I'm unclear what your variables are meant to achieve i.e. what year (calendar or financial) you are trying to align the first date to

Are you able to share your Dynamic P&L table data at all, at least a small sample of it? Please remove any sensitive data.

Pete

[anwargabr]

Yes, I can share.