Forum Discussion

frankGB's avatar
frankGB
Frequent Visitor
4 years ago

Dynamic DAX date table based on a reference date from a Filter

Hi,   I am trying to create a dynamic date table in DAX with calcualted dates based on a in a filter selected reference date.    Let's say the selected reference date in the filter visual is 15/0...
Need Help
frankGB's avatar
frankGB
Frequent Visitor
4 years ago

I was hoping I can create a table rather then measures for each of the calculated days then.

 

Are you aware of any soltion for a table?  

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi frankGB ,

 

Is this table a calculated table? If so, it is not possible. The calculation table is calculated when the model is refreshed, and user operations on the report do not affect the calculated table. (e.g. using a slicer)

Hope this will help you.

 

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

  • frankGB's avatar
    frankGB
    Frequent Visitor
    4 years ago

    yes, it is a calculated table. I could also create it as a static table in M and then probably do the Max and Min calculations based on a reference date to find the dates to be included in the visual. 

     

    I'll give that a try.