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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.