Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have a massive table with 50+ columns in Power BI. I want to create a brand new table, and select just 5 columns, and also filter out blank values for all of these columns
The table should look like this -- note there are no blank values, even if the original table has multiple order ID repeating without any values
Hi @Anonymous ,
For creating a new table out of your big table, you can simple use the following DAX for New table creation:
Hello @Pragati11 : Here's an example of my table, below, which shows the blank values -- if I were to filter them out, there would be only one Order ID, with no blank entries
I just do not know how to use filter and not(isblank()) DAX with Select Columns statement...
Hi @Anonymous ,
As you say only one order Id will be remaining in the table after removing blanks, does that mean removing any Order IDs that don't have values in other 3 columns?
Can you paste the expected output please? Also share your input data in a format so that I can easily copy and paste it in Power BI.
Thanks,
Pragati