Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
For the first one @sesa145093 this will work:
if [Status] = "(4) Completed" then Text.From([Debrief Year]) & "_" & [Entity] else null
All Power Query if/then/else constructs are logically like Excel's IF() statement, but it is if/then/else with two requirements:
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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingYou 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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingFor the first one @sesa145093 this will work:
if [Status] = "(4) Completed" then Text.From([Debrief Year]) & "_" & [Entity] else null
All Power Query if/then/else constructs are logically like Excel's IF() statement, but it is if/then/else with two requirements:
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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingAwesome!! 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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.