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/pa...
date slicer
Date Table
DAX
PowerBI Community
  • Fowmy's avatar
    Fowmy
    5 years ago

    01_RAF_01 

    Unfortunately no, that is how the model works.


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? 

  • Fowmy's avatar
    Fowmy
    Super User
    5 years ago

    01_RAF_01 

    Unfortunately no, that is how the model works.