IF statement returns 2 options per line.

Question

&nbsp;I want a field that designates if a customer is growing or declining. I've tried a Dax, custom column, etc.&nbsp; It continues to give two responses.&nbsp; In the orignal data the sales field has custom columns that designate if it's current or past sales.&nbsp;&nbsp;Latest try was:&nbsp;Cust Status =&nbsp;IF('Export Worksheet'[PY Net Sales $] &gt; 'Export Worksheet'[CY Net Sale $], "Declining","Growing")

jihwan_kim · Accepted Answer

Hi,&nbsp;Thackeb&nbsp;Please correct me if I wrongly understood your question.If you want to show "Grow" or "Decline" as a column in the visualization, in my opinion, the additional table is needed something like the below.Please check the picture and the sample pbix file's link down below whether it is what you are looking for.All measures are in the sample pbix file, and all steps are numbered in front of each measure.&nbsp;&nbsp;https://www.dropbox.com/s/m3szqz8cq2hhje2/thackeb.pbix?dl=0&nbsp;&nbsp;Hi, My name is Jihwan Kim. &nbsp;If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up. &nbsp;Linkedin: linkedin.com/in/jihwankim1975/Twitter: twitter.com/Jihwan_JHKIM

Forum Discussion

IF statement returns 2 options per line.

2 Replies

Related content

If Statement Calculated Column Returning Incorrectly

VAR Table in RETURN statement

issues with RETURN statement from variables

Return Filter from Switch Statement DAX

SQL statement to return data from current date to year prior range.