Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi team,
the database may have fact data at the detail level as well as tables containing aggregates of that detail data. The power BI tool can then determine which table to go against based on the query
can we do this in power BI?
Solved! Go to Solution.
Hi @Anonymous ,
I'd like some sample data and expected result to help use clarify your requirement and test to coding formula.
In my opinion, you can build relationship between two tables, then you can use category fields from summary table and detail table amount fields with 'summary mode' to achieve this requirement.
Work with aggregates (sum, average, etc.) in the Power BI service
Aggregations in Power BI Desktop (Preview)
Regards,
Xiaoxin Sheng
Hi @Anonymous ,
I'd like some sample data and expected result to help use clarify your requirement and test to coding formula.
In my opinion, you can build relationship between two tables, then you can use category fields from summary table and detail table amount fields with 'summary mode' to achieve this requirement.
Work with aggregates (sum, average, etc.) in the Power BI service
Aggregations in Power BI Desktop (Preview)
Regards,
Xiaoxin Sheng
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
50 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |