Forum Discussion
Calculated column using DAX
Hi I am trying to create a column " Eligible"using dax. I have lead ID column in my table. If this column contains duplicate lead is then 1 St captured lead id should be eligible and other should b...
Hi jihwan,
Thank you so much for your support, DAX is working properly. Could you please help to combine two more condition in above DAX,
1. When payout in local currency =0 and payout in USD = 0 then " ineligible Emp not found"
2.when lead id " L/CR-000000000" or lead id =L/CR - 00000001 then ineligible, duplicate customer
Else eligible
Hi,
Please share your sample pbix file's link.
Thank you.