Forum Discussion

jamieham's avatar
jamieham
Icon for Helper II rankHelper II
6 years ago

SWITCH

I'm trying to create a new column using the SWITCH function and I'm using the DAX formula below. The issue I have is if there is a blank for Gainline Prev the DAX formula is reading it as a 0 and add...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI jamieham 

 

In the filter pane for the Gainline Prev, you can say to ignore blank as below