Forum Discussion
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 ...
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
Could you share a couple of the records with the old and new names so i can test why they're not changing. Or could you share you PBIX file?
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Thanks a lot for your help.
I'll share the pbix soon and it might delay some time for other urget matter.
Thanks a lot for your help again.
Regards,
KMT