PowerBI Custom Column Mutiple Condition

Question

Hi there,

I need to insert a custom column in PowerBI. The column should return the value of an existing column 'ava_presalesamount' if 2 conditions are met: the column 'promotie.ava_name needs to contain "DGO" and the date needs to be before today. If this is not the case, the column needs to return the value of another column 'ava_builtondsiplay'.

I used the following code:

if Text.Contains([Promotie.ava_name], "DGO") and ([Date]< DateTime.Date()) then [ava_presalesamount] else [ava_builtondisplay].

For all the rows where 'promotie.ava_name' does contain "DGO", an Error appears. For the other rows 'ava_builtondsiplay' is returned, as should be the case.

Could someone help me out here?

Answer 1

Power Bi is not currently supported here on QnA. They're actively answering questions in dedicated forums here.
https://community.powerbi.com/
https://social.technet.microsoft.com/Forums/en-US/home?category=powerbi

--please don't forget to Accept as answer if the reply is helpful--

---

Regards, Dave Patrick ....
Microsoft Certified Professional
Microsoft MVP [Windows Server] Datacenter Management

Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.