topic Variable date table with parameter as enddate in DAX Commands and Tips

Variable date table with parameter as enddate

01_RAF_01 — Thu, 27 May 2021 07:50:24 GMT

Hi Im trying to make a calendartable with the enddate based on a parameter.

These are the parameter values. My goal is to set the enddate based on today + the value selected by the slicer/parameter

This is a part of the table where i set my start and enddate but unfortunatelly this way it doesnt work :

DIM_Dates =

ADDCOLUMNS (

CALENDAR (DATE(2020,1,1), Today()+Enddate[daysinfuture]),

"DateAsInteger", FORMAT ( [Date], "YYYYMMDD" ),

"Year", YEAR ( [Date] ))

Help/ tips are welcome how to fix this.

Re: Variable date table with parameter as enddate

Fowmy — Thu, 27 May 2021 07:58:43 GMT

01_RAF_01

Your selection in the parameter can not be included in the Calendar table, when you create a table, it gets loaded to the model and any value from the report or slicers cannot affect the tables in the model.

Re: Variable date table with parameter as enddate

01_RAF_01 — Thu, 27 May 2021 08:09:40 GMT

thanks for your reply Fowmy Are there any workarounds you know that can make this work?

Re: Variable date table with parameter as enddate

Fowmy — Thu, 27 May 2021 08:18:43 GMT

01_RAF_01

Unfortunately no, that is how the model works.