Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

if statement power query

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

 

4 REPLIES 4
Fowmy
Super User
Super User

@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 🙂


Website YouTube  LinkedIn

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Anonymous
Not applicable

here it is 

Arsham_0-1607466578273.pngArsham_1-1607466603753.png

 

Fowmy
Super User
Super User

@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 🙂


Website YouTube  LinkedIn

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Anonymous
Not applicable

Thanks but it still is showing #ERROR. 

your second formula is exactly I copied above 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.