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 name and then the dates of that name.

 

Thanks for your help

 

DAX
Help required
if statement

4 Replies

  • 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 

  • Fowmy's avatar
    Fowmy
    Icon for Super User rankSuper User
    5 years ago

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      here it is