Forum Discussion
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...
Guys, Thanks
The problem was coming from calendar table as the max date was in last year.
Thanks
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
Yes, I can share.