Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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 nam...
DAX
Help required
if statement
Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
5 years ago

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

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks but it still is showing #ERROR. 

    your second formula is exactly I copied above