IF(ISBLANK... not really work

[azaterol]

Hey all,

I have a measure: 

First date when customer bought with blanks, if customer not bought= IF(ISBLANK([First date]),"",[First date])

There are customers who never bought, so they havent a first date time for buying. 

I want show all customers not just who bought first. If they not bought, in the cell should be blank, otherwise the date, like I wrote my DAX.

But this DAX formula combines all customers and give me many duplicates.

You have an idea how I can solve this.

Here an example what I want to show.

Max	John-Street 3	01.02.2003
Branda	Marple Street 2
Doe	Fantasy Street 99	20.01.2010
Karen	August Street 28

[v-eqin-msft]

Hi @azaterol ,

Glad to know that !

So could you please share your methods and then Accept the reply as the solution to make the thread closed ? More people will benefit from it.

Best Regards,
Eyelyn Qin

[v-eqin-msft]

Hi @azaterol ,

Any updates? Please feel free to ask.

Best Regards,
Eyelyn Qin

[azaterol]

hello @v-eqin-msft  , I have the solution for my question. Thank you for asking me !

[v-eqin-msft · Accepted solution]

Hi @azaterol ,

Maybe I'm misunderstanging...

According to this: I want show all customers not just who bought first. 

How about simply using Table visual ?  Blanks would not be filtered out:

If you are still confused about it, share more details to help us clarify your scenario.

How to Get Your Question Answered Quickly - Microsoft Power BI Community

How to provide sample data in the Power BI Forum - Microsoft Power BI Community

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Firstly - learn about COALESCE()

Secondly - whitespace reporting requires you to bring your own cartesian product.  Otherwise your attempt to report on things that aren't there will fail.

Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to assist you. I cannot use screenshots of your source data.

Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523