Forum Discussion
Trouble creating a Concatenate Column
This is the string i have used in Excel: =IFERROR(IF([@Status]="(4) Completed",CONCATENATE([@DebriefYear],"_",[@Entity]),""),NA())
I have the same data in Power Bi I just cant figure out how to get either a custom column to do this or how to create a measure.
This is the Secon field i will need as well: =IFERROR(IF([@Status]="(4) Completed",IF((COUNTIFS([Entity Concat1],[@[Entity Concat1]])-COUNTIF($AF$2:$AF2,$AF2))=0,1,0),""),NA())
Thank you for your help!
For the first one sesa145093 this will work:
if [Status] = "(4) Completed" then Text.From([Debrief Year]) & "_" & [Entity] else nullAll Power Query if/then/else constructs are logically like Excel's IF() statement, but it is if/then/else with two requirements:
- The keywords if, then, and else, are lower case.
- You must have the else statement. If you don't need it, just use else null. Unlike IF() you cannot leave the else off.
As for your second question, we need data. I have no idea what is in AF2 or what you are trying to accomplish there.
How to get good help fast. Help us help you.
How To Ask A Technical Question If you Really Want An Answer
How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.Awesome!! Thanks for this!!
You are welcome sesa145093 - I hope you don't mind but I marked my answer as the solution since it had the working code. 😁
If you need help with the 2nd part of your question, you could start a new thread for just that including some sample data and expected results per the links in my post above.
3 Replies
For the first one sesa145093 this will work:
if [Status] = "(4) Completed" then Text.From([Debrief Year]) & "_" & [Entity] else nullAll Power Query if/then/else constructs are logically like Excel's IF() statement, but it is if/then/else with two requirements:
- The keywords if, then, and else, are lower case.
- You must have the else statement. If you don't need it, just use else null. Unlike IF() you cannot leave the else off.
As for your second question, we need data. I have no idea what is in AF2 or what you are trying to accomplish there.
How to get good help fast. Help us help you.
How To Ask A Technical Question If you Really Want An Answer
How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.Awesome!! Thanks for this!!
You are welcome sesa145093 - I hope you don't mind but I marked my answer as the solution since it had the working code. 😁
If you need help with the 2nd part of your question, you could start a new thread for just that including some sample data and expected results per the links in my post above.