Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Fetching data from aggred table located in table cell

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's avatar
    Anonymous
    6 years ago
    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.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    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.