Forum Discussion

anwargabr's avatar
anwargabr
Icon for Helper I rankHelper 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
Icon for Super User rankSuper User
5 years ago

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's avatar
anwargabr
Icon for Helper I rankHelper I
5 years ago

Yes, I can share.