Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi folks,
I have pulled one table using Odata query.
let
Source = OData.Feed("SiteURL/_Api/ProjectData"),
Assignments_table = Source{[Name="Assignments",Signature="table"]}[Data]
in
Assignments_table
This table having some column like Project, Resource, task etc. all are record type.
Is there any idea how to filter all this rows based on some conditions. And these conditions should be applied on these columns's record. There is option of expanding these columns, but getting some error while expanding due to large data. Hence need to know any filter code without expanding these columns.
Solved! Go to Solution.
Hi @pratk30,
I'm wondering if you could firstly create new columns to get filtered record columns, then delete the original record columns, and last expand the new ones in your scenario.
The query below to create a new column to get filtered record columns for [Baseline] is for your reference.
=Table.SelectRows(Table.FromRecords([Baseline]), each condition applied on columns within record)
Regards
Hi @pratk30,
I'm wondering if you could firstly create new columns to get filtered record columns, then delete the original record columns, and last expand the new ones in your scenario.
The query below to create a new column to get filtered record columns for [Baseline] is for your reference.
=Table.SelectRows(Table.FromRecords([Baseline]), each condition applied on columns within record)
Regards
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |