question

lasma avatar image
lasma asked

How to use the BLANK () Function in DAX

Hi Experts! What is wrong with the following DAX Expression... =IF( [UnitPriceDiscountPct] = 0, BLANK () , [UnitPriceDiscountPct] * [SalesAmount] ) It is just a simple example taken from the FactInternetSales table in AdventureworksDW. When I try to add it as a Calculated Column, I got the following... "The syntax for Blank is incorrect...." and so on Anyone who can see the error? Thanks
power-pivot
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
lasma avatar image
lasma answered
Problem soled. I used Semi-colons instead of commas inside the IF statement...
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.