Time intelligence without date filter on the Dashboard

[mlovejoy]

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))

[v-jianboli-msft]

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.