Forum Discussion

WYSE595's avatar
WYSE595
Regular Visitor
4 years ago

Search for specific text and return one result

Hi, I am a relative newbie and am trying to do something that I can't find the answer to anywhere and am hoping you can help.   I have a table which contains a list of different Process Areas which...
Need Help
v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

Hi, WYSE595 ;

You could create a custom column in power query .

= Table.AddColumn(#"Removed Columns", "Custom", each if Date.Month([Meeting Date] ) <=6 then "H1" else "H2")

 Or you could create a measure in desktop.

= Table.AddColumn(#"Removed Columns", "Custom", each if Date.Month([Meeting Date] ) <=6 then "H1" else "H2")

The final show:

If i understand error, can you share more logic and the result you want to ouput?


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • BA_Pete's avatar
    BA_Pete
    Super User
    3 years ago

    v-jingzhang 

     

    I have removed the solution recently applied to this post. This clearly does not solve the OP's (albeit vague) question.

    OP already has the half-year column, they appear to require that the table is adjusted to show where either at least one meeting has taken place during the half-year, or none.

     

    Pete