The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello
I want to create the result table with Dax.
Could you help me ?
TableA
Catergory | Value |
A | 5 |
B | 8 |
C | 12 |
TableB
Catergory | Charge |
A | 2 |
B | 3 |
C | 4 |
ResultTable
Category | Number |
A | 6 |
A | 7 |
B | 9 |
B | 10 |
B | 11 |
C | 13 |
C | 14 |
C | 15 |
C | 16 |
Solved! Go to Solution.
SELECTCOLUMNS(
GENERATE(
TableA,
var Val = TableA[Value]
var Cat = TableA[Category]
var Chrg =
LOOKUPVALUE(
TableB[Charge],
TableB[Category], Cat,
BLANK()
)
var Nums =
SELECTCOLUMNS(
GENERATESERIES(
Val + 1,
Val + Chrg,
1
),
"@Number", [Value]
)
return
Nums
),
"Category", TableA[Category],
"Number", [@Number]
)
Another way would be:
SELECTCOLUMNS(
GENERATE(
NATURALINNERJOIN(
TableA,
TableB
),
var Val = TableA[Value]
var Cat = TableA[Category]
var Chrg = TableB[Charge]
var Nums =
SELECTCOLUMNS(
GENERATESERIES(
Val + 1,
Val + Chrg,
1
),
"@Number", [Value]
)
return
Nums
),
"Category", TableA[Category],
"Number", [@Number]
)
SELECTCOLUMNS(
GENERATE(
TableA,
var Val = TableA[Value]
var Cat = TableA[Category]
var Chrg =
LOOKUPVALUE(
TableB[Charge],
TableB[Category], Cat,
BLANK()
)
var Nums =
SELECTCOLUMNS(
GENERATESERIES(
Val + 1,
Val + Chrg,
1
),
"@Number", [Value]
)
return
Nums
),
"Category", TableA[Category],
"Number", [@Number]
)
Thank you So much!!
User | Count |
---|---|
27 | |
12 | |
8 | |
8 | |
5 |
User | Count |
---|---|
31 | |
15 | |
12 | |
7 | |
6 |