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

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.

Reply
NatashaSchuster
Helper II
Helper II

Passing variables inside DATATABLE()

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

 

1 ACCEPTED SOLUTION
Zubair_Muhammad
Community Champion
Community Champion

@NatashaSchuster

 

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)

Regards
Zubair

Please try my custom visuals

View solution in original post

1 REPLY 1
Zubair_Muhammad
Community Champion
Community Champion

@NatashaSchuster

 

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)

Regards
Zubair

Please try my custom visuals

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.