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 all,
can anyone help me?
I am using the below formula but the results are "Error".
column name =IF(Tasks[TaskName]="Initiation",Tasks[TaskStartDate].[Date],"")
I want to find a specific name and then the dates of that name.
Thanks for your help
@Anonymous
Please share the screenshot with the error.
________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
here it is
@Anonymous
If you do it in Power Query then:
=if Tasks[TaskName]="Initiation" then Tasks[TaskStartDate] else null
If you are adding it as a column using DAX in your data model then:
column name =IF(Tasks[TaskName]="Initiation",Tasks[TaskStartDate],"")
________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Thanks but it still is showing #ERROR.
your second formula is exactly I copied above
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 |
---|---|
43 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
45 | |
31 | |
30 | |
18 | |
17 |