Fetching data from aggred table located in table cell

[Anonymous]

Hey,

I'd like to know if it's possible to refer table contents in a cell with DAX?

Here is a picture of my table. It's now agrregated with two columns CellName and LocalDate and original aggregated column is DateActions. Columns right from that (there is more of them) are duplicates of DateActions but they have been aggregated to show sums.

I want to know if I can refer to those Tables in DateActions columns cells in DAX? That would be great so I can aggregate only with LocalTime and model could be unified when there is only one entry/date in this table.  I'd like to be able to filter those numbers with CellName so that's why I need DAX-expression to dive to those tables inside column.

Hope this was at least mediocre explanation of a problem.
Thanks!

[Anonymous · Accepted solution]

This has nothing to do with DAX. You're presenting and talking about Power Query. You cannot import a table like this into Power BI. Tables cannot be stored into columns in Power BI and manipulated with DAX.

[amitchandak]

@Anonymous , I did not get completly.

Click on those expand icon in date action and check for the options.

refer :https://datachant.com/2017/02/07/power-bi-pitfall-9/