Forum Discussion
Solved
Need Help with DAX if statment
Hello, I just started using power BI and was wondering if I could get some help. I have 3 tables, Current customers, Our Historic List and a third table that needs to be filled. The third...
create a calculated column in current customers table to identify id present in historic customers table.
present historic id = LOOKUPVALUE(Historic List[Customer ID historic],Historic List[Customer ID historic],Current customers[Customer ID current])This above dax will give you a column that displays customer id present in historic customer table and new customer id as blank.Then create a measure to count blank rows as follows,COUNTBLANK(Current customers[present historic id])Total blank rows in column 'present historic id' will give you total no.of. new customer ids.If this post helps you to resolve your problem, then mark it as 'Accept as solution' below.
create a calculated column in current customers table to identify id present in historic customers table.
present historic id = LOOKUPVALUE(Historic List[Customer ID historic],Historic List[Customer ID historic],Current customers[Customer ID current])
This above dax will give you a column that displays customer id present in historic customer table and new customer id as blank.
Then create a measure to count blank rows as follows,
COUNTBLANK(Current customers[present historic id])
Total blank rows in column 'present historic id' will give you total no.of. new customer ids.
If this post helps you to resolve your problem, then mark it as 'Accept as solution' below.
Thank you so much that helped.