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

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.