Forum Discussion

KyawMyoTun's avatar
KyawMyoTun
Helper IV
3 years ago
Solved

Create Customer table from Sale table with multiple Customer Names

Dear Experts,   I am trying to create a new unique "Customer" table from existing Sale table in dax. Actully it can be created by using Summarize function with the reuqired columns. The problem ...
Need Help
  • KyawMyoTun's avatar
    KyawMyoTun
    3 years ago

    Dear DOLEARY85 ,
    I have tried and some old names still because of FIRSTNONBLANK function I think.
    So, I tried with LASTDATE function of Order date and it gave me the expected results.
    Pbix file is not able to share for me.
    So, Please check the screenshot and let me know your thought.
    Thanks a lot for your help.

     

     



    Best Regards,
    KMT

KyawMyoTun's avatar
KyawMyoTun
Helper IV
3 years ago

Dear DOLEARY85 ,
I have tried and some old names still because of FIRSTNONBLANK function I think.
So, I tried with LASTDATE function of Order date and it gave me the expected results.
Pbix file is not able to share for me.
So, Please check the screenshot and let me know your thought.
Thanks a lot for your help.

 

 



Best Regards,
KMT

DOLEARY85's avatar
DOLEARY85
Resident Rockstar
3 years ago

Hi,

 

yeah that looks good, FIRSTNONBLANK should have worked too due to it being filtered by the max order date. Without seeing the PBIX file i'm not sure why that didn't work but if adapting my solution with LASTDATE gives you what you need then that's great. Glad it worked.

 

happy to help ðŸ™‚

  • KyawMyoTun's avatar
    KyawMyoTun
    Helper IV
    3 years ago

    Dear DOLEARY85 ,

      The expected result is coming of adapting your solution.

    Thanks for helping. Happy learning.

    Regards,
    KMT