Share
ReportHello community,
I'm from PowerBI and new to Power Apps.
I have a Table A: (~100k rows)
| Attribute | Amount |
| A | 1 |
| B | 2 |
| A | 1 |
| C | 3 |
and Table B: (Attribute being unique)
| Attribute | Category |
| A | Alpha |
| B | Beta |
| C |
Cat
|
They are saved as Excel in my Onedrive and I imported them into Dataverse.
I would want to let Table A left join Table B and build:
1. A label showing sum(Amount) with slicers of Category from Table B
2. A gallery showing Attribute, Category and Amount
After some searches on the internet, my problem is I don't know how to join these tables together. I don't think Dataverse can build data model relationships like Power BI. Also, when I import data into dataverse, I tried to change [attribute] to lookup column but it seems I cannot do it. And Addcolumn function seems don't work since it has a row count limit of 500. So I'm stuck.
Appreciate for the help!
Categories:
I have the same question (0)
All responses (
Answers (
342
