Forum Discussion

azaterol's avatar
azaterol
Icon for Helper V rankHelper V
4 years ago
Solved

IF(ISBLANK... not really work

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.
MaxJohn-Street 3

01.02.2003

BrandaMarple Street 2 
DoeFantasy Street 9920.01.2010
KarenAugust Street 28 
Need Help

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi azaterol ,

     

    Any updates? Please feel free to ask.

     

    Best Regards,
    Eyelyn Qin

    • azaterol's avatar
      azaterol
      Icon for Helper V rankHelper V
      4 years ago

      hello Anonymous  , I have the solution for my question. Thank you for asking me !

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    4 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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