Forum Discussion
Max slicer date as input for dateadd
Hello, MM_NL
The Syntax of DATEADD function isDATEADD(<dates>,<number_of_intervals>,<interval>)
<dates> is column, not scalar value. MAX (Period) isn't work. You must set column, if you need only one date, you can use construction something like this:
DATEADD ( FILTER ( Table[Period], Table[Period] = MAX (Table[Period] ) ), .......)I solved it, by replacing the table input in the filter expression by lastdate() on the date column
Old:
DATEADD(FILTER(Period, Period[Datecolumn] = max(Period[Datecolumn]))
New
DATEADD(FILTER(LASTDATE(Period[Datecolumn]), Period[Datecolumn] = max(Period[Datecolumn]))
this way the filter expression accepted a column input instead of whole table
Thank you Popov!
Hello, MM_NL
The Syntax of DATEADD function is
DATEADD(<dates>,<number_of_intervals>,<interval>)
<dates> is column, not scalar value. MAX (Period) isn't work. You must set column, if you need only one date, you can use construction something like this:
DATEADD ( FILTER ( Table[Period], Table[Period] = MAX (Table[Period] ) ), .......)
I tried this and the error i get now is:
"A table expression containing more than one column was specified in the call to function 'dateadd'. this is not supported"
Can you share your formula?
I solved it, by replacing the table input in the filter expression by lastdate() on the date column
Old:
DATEADD(FILTER(Period, Period[Datecolumn] = max(Period[Datecolumn]))
New
DATEADD(FILTER(LASTDATE(Period[Datecolumn]), Period[Datecolumn] = max(Period[Datecolumn]))
this way the filter expression accepted a column input instead of whole table
Thank you Popov!