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

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

  • parry2k's avatar
    parry2k
    Super User
    8 years ago

    i guess it need bit more tweaking, can you share your data in excel sheet and get back to you with solution. cheers!

    • js2246's avatar
      js2246
      Frequent Visitor
      8 years ago

      I was just using the example data and variable definitions shown in the original post. I can't share my actual data of millions of records but I figure if we could get this short example problem working then I could apply the solution to my actual data. Thanks for your help!

      • parry2k's avatar
        parry2k
        Super User
        8 years ago

        no problem, will work on it tomorrow.