Forum Discussion

mlovejoy's avatar
mlovejoy
Icon for Helper I rankHelper I
3 years ago

Time intelligence without date filter on the Dashboard

Hello community,

I want to put a parameter in my DATEADD function. The formula works fine but only when I put the date slicer on the dashboard (giving the date context to my formula). The only issue is that I don't want this slicer so I need to put the Date context in my formula. This context musst always be the max date, so when I enter 30 days in my parameter value it will do Max date - 30 days.

Any help? 🙂

 

Thanks

 

Accepted AY (date) test =
CALCULATE(CALCULATE([Accepted AY (intake)] ,
USERELATIONSHIP(Enrollments[AcceptanceDate] , Dates[Date])) , DATEADD(Dates[Date] , -[Parameter Value] , DAY))

1 Reply

  • v-jianboli-msft's avatar
    v-jianboli-msft
    Icon for Community Support rankCommunity Support
    3 years ago

    Hi mlovejoy ,

     

    Sorry for that the information you have provided is not making the problem clear to me. Can you please share more details to help us clarify your scenario?

    Please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

     

    Refer to:

    How to provide sample data in the Power BI Forum

    How to Get Your Question Answered Quickly

     

    Best Regards,

    Jianbo Li

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