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.
Hello everyone.
I want to create from my current table two tables:
-One with all the elements without the rows that have any"Estado Deseado en ..." and "Priorizado en el ...".
-Other table only with all the "Estado Deseado en..." and "Priorizado en..."
In other words, I want to have a table with all the "Estado actual por Quincena..." and other with the "Estado deseado en..." and "priorizado en..."
Thanks!
Solved! Go to Solution.
Hi @Plopez13
On Modeling in the ribbon, create new tables with this
FILTER(
YourTableName,
LEFT(Fechas, XX) = "Estado Deseado en" ||
LEFT(Fechas, XX) = "Priorizado en el"
)
FILTER(
YourTableName,
LEFT(Fechas, XX) <> "Estado Deseado en" &&
LEFT(Fechas, XX) <> "Priorizado en el"
)
In the code where I put XX, figure out how long each of those strings are and use that number.
Hope this helps!
Hi @Plopez13
On Modeling in the ribbon, create new tables with this
FILTER(
YourTableName,
LEFT(Fechas, XX) = "Estado Deseado en" ||
LEFT(Fechas, XX) = "Priorizado en el"
)
FILTER(
YourTableName,
LEFT(Fechas, XX) <> "Estado Deseado en" &&
LEFT(Fechas, XX) <> "Priorizado en el"
)
In the code where I put XX, figure out how long each of those strings are and use that number.
Hope this helps!
@Plopez13 You can do this in Power Query. Start with your original data - rename this query to put RawData_ in front of the table name.
Right click on the query in Queries pane > Reference. Filter this new table for text contains "Estado Deseado en " OR text contains "Priorizado en el"
Then repeat for the other table - right click the RawData_ table, reference. In the new table filter for your other conditions.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
User | Count |
---|---|
70 | |
70 | |
34 | |
23 | |
22 |
User | Count |
---|---|
96 | |
94 | |
50 | |
42 | |
40 |