How to write conditioned DAX

[Hadill]

Hi there,

I am trying to type a DAX formula that satisfies the following condition:

if the 'sales'[sales-number] contains Number, then print 'Sold Out'

and if it is empty, then print 'Ready for Sale'

advince thanks for helping.

[ValtteriN · Accepted solution]

Hi,


Like Amit said you can use PQ or if you want a dax solution:

You can achieve this by either checking for blank

IF(SELECTEDVALUE('ALL'[Value])=BLANK(),"Ready for Sale","Sold Out")

Or checking for number: 

IFERROR(

IF(

ISNUMBER(VALUE(max('ALL'[Value]))),"Sold Out"),"Ready for Sale")


Example:

 

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

[amitchandak]

@Hadill , create a new column in power query

if [Column] =null then "Ready for Sale"
else if Value.Is([Column], Int64.Type) then "Sold Out" else "Other"