Forum Discussion
IF statement sort to remove blank values
I currently have a sort function to only include values: "company A" and "All Other" yet my %s are a little off, is there a way to remove blank/null values from this via DAX formula? (as I assume the...
Hi Anonymous ,
Can you pls elaborate on the problem you are facing.
Also, any specific reason of using this twice in you formula.
Company Supplier Sort = IF([Company_Supplier_Name] = "Company A" || [Company_Supplier_Name] = "Company A",[Company_Supplier_Name], "All Other")
Regards,
HN