Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I am using PBI to pull data from Project Online in order to create a table that accomplishest the following:
Below is the formula I've been trying:
Here is an example of what the end results I am after:
HI @Anonymous ,
For string comparison in dax, you can refer to following blog to know more about these:
From SQL to DAX: String Comparison
In addition, I think search/find function should more suitable for your requirement.
Complete Testing = IF( SEARCH( "Complete testing", [Task Name], 1, 0 ) > 0,[Task Finish Date],0)
If above not help, please share some sample data with expected result for test.
Regards,
Xiaoxin Sheng
Hi @v-shex-msft ,
Thank you very much for sharing this! I will check out the blog post as well as try your proposed function and proviode feedback on my results.
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |