Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Anonymous
Not applicable

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.
Explanation.png

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!

1 ACCEPTED SOLUTION
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.

View solution in original post

2 REPLIES 2
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.
amitchandak
Super User
Super User

@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/

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.