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.
Buena tarde, se que el titulo es algo confuso pero es basicamente lo siguiente, al modelar mis datos me quedo esto
Tengo una tabla como columna y quisiera saber si es posible filtrar la informacion de la tabla "base", utilizando la fecha de la tabla normal para filtrar los datos de la tabla "base"
Solved! Go to Solution.
Hi @Jose_Sierra ,
You can use Table.SelectRows.
Try like
let myyear=Date.FromText("2020-5-1")
in
Table.SelectRows([Base], each [Date] >= myyear)
See the details from the attachment.
Reference: Reference a column to filter a nested table in Power Query?
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Jose_Sierra ,
You can use Table.SelectRows.
Try like
let myyear=Date.FromText("2020-5-1")
in
Table.SelectRows([Base], each [Date] >= myyear)
See the details from the attachment.
Reference: Reference a column to filter a nested table in Power Query?
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering 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.