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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.