Forum Discussion

01_RAF_01's avatar
01_RAF_01
Frequent Visitor
5 years ago
Solved

Variable date table with parameter as enddate

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. 

date slicer
Date Table
DAX
PowerBI Community

3 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    5 years ago

    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.

    • 01_RAF_01's avatar
      01_RAF_01
      Frequent Visitor
      5 years ago

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