Forum Discussion

admin_xlsior's avatar
admin_xlsior
Icon for Post Prodigy rankPost Prodigy
6 years ago

Selected date from DATE SLICER

Hi ,   I have a requirement for Date selection in Power BI. Basicaly what we need is only 1 single date and this single date will be the base of many calculation in the future.    At first I 'm u...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Try like

'AsOfDate' = MAXX('Date','Date'[Date])
admin_xlsior's avatar
admin_xlsior
Icon for Post Prodigy rankPost Prodigy
6 years ago

Hi,  it's the same error. "MAXX is not allowed as part of calculated column...."

 

I think this is related to "Unrestricted measures of Direct query". They used to have options to "Allow unrestricted measures for Diect Query" in Options and Setting, but this option is gone.

 

Thanks,

  • dax's avatar
    dax
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi admin-xlsior,

    When use Direct Query,  some function can't be used in calcuated column, you could refer to DAX formula compatibility in DirectQuery mode for details.

    In addition, you said that you use "before" in slicer, I think which work like a calendat picker

    You could choose date in calendar instead of use max date.

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    • admin_xlsior's avatar
      admin_xlsior
      Icon for Post Prodigy rankPost Prodigy
      6 years ago

      Hi,

       

      Yes, the calendar tool is working fine. I can input using that or the slider. But I need to capture the value for my next formula. That's why I'm using MAX because I only want to get the 2nd value ("To" date)

       

      That's is why I'm using DAX. But currently I get error because it is not allowed.

       

      Thanks,