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
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.

  • js2246's avatar
    js2246
    Frequent Visitor
    8 years ago

    I don't know what I'm doing wrong then because I can't get the slicer to change anything.  Var1 is set to the sum, and clicking on different dates doesn't effect it at all.  Do you see something I'm doing wrong?

     

    • parry2k's avatar
      parry2k
      Super User
      8 years ago

      Seems like you are adding var1 as column whereas it need to be Measure since you are using sum aggregation.

      • js2246's avatar
        js2246
        Frequent Visitor
        8 years ago

        I'm not sure how to write this as a measure. 

        I get the error a single value for 'Date1' in table 'Sheet1 cannot be determined. This can happen when a measure formula refers to a column that contains many values whithout specifying an aggregation.... 

         

        I wouldn't think aggregating the dates would work since the vars are defined independently from them