Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello,
Is there a way to pass variables inside DATATABLE() ? Documentation says it's not but I still would like to see if someone came up with hack to do that.
here is the example. I would like to pass varaibles One, Two, Three as a second value in a row constructor inside DATATABLE( )
DEFINE
VAR Three = 3
VAR Two = 2
VAR One = 1
VAR cars = DATATABLE(
"Maker", STRING, "Sales", INTEGER, {
{ "Ford", 3 }, // I would like to pass variables from above { "Ford", Three }
{ "Jaguar", 2},
{ "Jaguar", 1 }
})
EVALUATE
FILTER(
cars,
[Sales] >= 2
)Thanks
Solved! Go to Solution.
@Anonymous
An alternative could be
Table = VAR Three = 3
VAR Two = 2
VAR One = 1
VAR cars = { ("Ford", Three), ("Jaguar", 2),("Jaguar", 1 )}
RETURN
FILTER(cars,[Value2] >= 2)
@Anonymous
An alternative could be
Table = VAR Three = 3
VAR Two = 2
VAR One = 1
VAR cars = { ("Ford", Three), ("Jaguar", 2),("Jaguar", 1 )}
RETURN
FILTER(cars,[Value2] >= 2)
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 36 | |
| 33 | |
| 33 | |
| 29 |
| User | Count |
|---|---|
| 132 | |
| 90 | |
| 78 | |
| 66 | |
| 65 |