Forum Discussion
Allisond
Advocate II
Advocate IIUsing VAR if returns BLANK then next Calculation in Switch True
Good Afternoon, This is a small sample of what I am trying to do to get a value closest to a date. I have multiple VAR for -29 days, -31 days etc.. Please see below. My first Result for "Th...
Hi Allisond
It's abit complicated to understand but looking at your SWITCH, the order of the logic needs changing. If ValidRow is True then the 2nd line (ValidRow && ThirtyDWt) will never be evaluated
Try this
Return SWITCH( TRUE(), ValidRow && ThirtyDWt = BLANK(), ThirtyMin1Wt, ValidRow, ThirtyDWt, BLANK() )Regards
Phil
PaulDBrown
Community Champion
Community ChampionCould you please provide a sample dataset or PBIX file? And a depiction of what you are trying to calculate