HELP !! with changing my formula

[RvdHeijden]

I need to change my formula so that is works with BLANK values

Productie per dag = SUMMARIZE(GENERATE(Adressen;CALCULATETABLE(VALUES('Date'[Date]);DATESBETWEEN('Date'[Date];Taken[begin];Taken[Eind])));Adressen[DP gebied naam];'date'[Date])

It has effect on the 'red' part of the formula which calculates the Datesbetween 2 colums and sometimes there is no value.

Now ... it returns an error translated into 'A single value cannot be determined for column 'Begin' in table 'Taken' 

Which probably has something to do with the fact that there are blank values right ?

[Greg_Deckler]

Might be, or it might be that if that is a measure that you need an aggregation around that column. If it is blank, what do you want it to be?

[RvdHeijden]

@Greg_Decklerif there is a blank value the formula should return a blank value too

[Greg_Deckler]

You can handle that via something like:

IF(ISBLANK(MAX('Table'[BeginTime])),BLANK(),<your calculation>)

[RvdHeijden]

@Greg_Deckler i cant get the formula to work but not such a datanaut as you are 😉

Productie per dag = SUMMARIZE(GENERATE(Adressen;CALCULATETABLE

(VALUES('Date'[Date]);(IF(ISBLANK(MAX(Taken[begin]));BLANK());DATESBETWEEN('Date'[Date];Taken[begin];Taken[Eind])));Adressen[DP gebied naam];'date'[Date])))

it returns a syntax error so that probably means there are some )( wrong somewhere, can you help me out ?

[RvdHeijden]

@Greg_Deckler Any ideas ?