Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi guys,
I have a question:
I need to identify the first order (based on the date) for the person and insert "1" into the new column and for other orders (which are not first) insert 0.
One person can have 2 or more orders but 1 personal id.
Which DAX formula should I use?
Solved! Go to Solution.
Try this formula:
Hi,
Try this calculated column formula
=IF(Data[Date Created]=CALCULATE(MIN(Data[Date Created]),FILTER(Data,Data[Personal id]=EARLIER(Data[Personal id]))),1,0)
Hope this helps.
Hi @Anonymous,
By my tests, the solution from Ashish_Mathur and Arslan should be helpful.
If you have solved your problem, please accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please feel free to ask.
Best Regards,
Cherry
Hi @Anonymous,
By my tests, the solution from Ashish_Mathur and Arslan should be helpful.
If you have solved your problem, please accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please feel free to ask.
Best Regards,
Cherry
Done! 🙂
Hi,
Try this calculated column formula
=IF(Data[Date Created]=CALCULATE(MIN(Data[Date Created]),FILTER(Data,Data[Personal id]=EARLIER(Data[Personal id]))),1,0)
Hope this helps.
Thank you @Ashish_Mathur your formula was very useful!!! Sorry for the late reply 🙂
Try this formula:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |