zmansuri KRider Browse other questions tagged, Where developers & technologists share private knowledge with coworkers, Reach developers & technologists worldwide. Roverandom Much appreciated! Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders. Find out about what's going on in Power BI by reading blogs written by community members and product staff. In the place where there are 3 points in a row there is not such option in the scroll down menu maybe it's only allowed just one "solved" per post (thread), Yes you are right. Since i am using direct query I cannot do any transormations using M query. We are excited to kick off the Power Users Super User Program for 2023 - Season 1. Make sure you conduct a quick search before creating a new post because your question may have already been asked and answered! (function() { Since I want to display the two columns in one field, I created a a new column named "Author" (the one that is highlighted in the above image) using the below formula. By using if statements you ensure that your final output only includes the values that meet your specific requirements. Thank you very much! To exclude null values in a concatenation, you can use an if statement to check if a certain column contains a null value. They let you perform different operations depending on whether a condition is true or false. Could . Boolean algebra of the lattice of subspaces of a vector space? How to concatenate text from multiple rows into a single text string in SQL Server. calculate the maximum of the lenghts of each items on each row, maybe you have to use a dummy column with a value to concatenate further.. or maybe just a different . 2. Can you please explain how this makes sense? Front Door brings together content from all the Power Platform communities into a single place for our community members, customers and low-code, no-code enthusiasts to learn, share and engage with peers, advocates, community program managers and our product team members.