Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
01_RAF_01
Frequent Visitor

Variable date table with parameter as enddate

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

1.PNG

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

2.PNG

 

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. 

1 ACCEPTED SOLUTION

@01_RAF_01 

Unfortunately no, that is how the model works.


Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

3 REPLIES 3
Fowmy
Super User
Super User

@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.

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

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

@01_RAF_01 

Unfortunately no, that is how the model works.


Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors