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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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