Forum Discussion
Solved
Blank Values
Hi Guys, I created this Calculated table, and it seems to work pretty good, how can I handle the blank? Bascially to say if its blank then to print the word blank. Thanks
pfarahani Well, one way would be to incorporate the FILTER for removing the blank row from you CALCULATETABLE and do this:
Table = VAR __BlankTable = SELECTCOLUMNS( { ("Blank", "Blank", 1) },"DepartmentAbbreviation",[Value1], "CourtDept",[Value2],"Used",[Value3]) RETURN UNION( __BlankTable, <Your CALCULATETABLE with the FILTER for blank rows goes here> )
3 Replies
Greg_Deckler Hi Greg, I am up against a deadline on this! Any hints, how to incorporate Blanks into this syntax thanks
pfarahani Well, one way would be to incorporate the FILTER for removing the blank row from you CALCULATETABLE and do this:
Table = VAR __BlankTable = SELECTCOLUMNS( { ("Blank", "Blank", 1) },"DepartmentAbbreviation",[Value1], "CourtDept",[Value2],"Used",[Value3]) RETURN UNION( __BlankTable, <Your CALCULATETABLE with the FILTER for blank rows goes here> )
