Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

How to access object's property stored in column.

Hi All, 

 

This is my initial days of learning in Power BI, I have the requirement to access object's property which is stored in one of the columns

 

for eg:

 

[{"TaskID":100,"TaskTitle":"Test1","signup":true},{"TaskID":158,"TaskTitle":"Site library","signup":true},{"TaskID":171,"TaskTitle":"Dev White Space Test","signup":true},{"TaskID":182,"TaskTitle":"test2","signup":true},{"TaskID":193,"TaskTitle":"NEN -Europe- All Countries","signup":true},{"TaskID":192,"TaskTitle":"test3","signup":true},{"TaskID":227,"TaskTitle":"Testing is in progress","signup":true},{"TaskID":219,"TaskTitle":"test4","signup":true}]

I have this sort of data stored inside the cells in each row, I want to access in this array all "TaskTile" property's value and store it in another column. Please kindly help me on this.
Quick replies much appreciated.