Forum Discussion

js2246's avatar
js2246
Frequent Visitor
8 years ago

Dynamic Date

I have a case where I have mulitple dates that define unique variables and I want to be able to customize a date range where people can get totals based on the date range selected.   So for instanc...
Need Help
parry2k's avatar
parry2k
Super User
8 years ago

you need a date dimension table in your model, from that table use date as a slicer and in your formula replace "31-Jan-2017" with MAX(DateTable[Date])

 

 

  • js2246's avatar
    js2246
    Frequent Visitor
    8 years ago

    Thank you for your response but could you provide more details please. I'm newer to this.

    At what point do I do this? 

    If I create a date table based on entered data then try to create new columns for my calculated variables based on that datetable[date] then I would have to establish some sort of relationship between the date table and my original table correct? And I can't establish a relationship between the datatable[date} and all of my dates, correct?

     

    I tried no relationship and created new column  var1 = if (sheet1[Date1]<max(datetable[date]),1,0) 

    and for daterange[date] i filtered to one date value but my var1 result is not effected.