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
Trabka
Frequent Visitor

Can I pass a reference to a custom column creation

Hi there, sorry just one more thing.

 

I am trying to pass w parameter or refernce for creating custom table. Is it possible ?

 

Ua case:

 

From previous problem which I had I am able to find the column Header name which I want to pass to the Next Custom Column Condition.

 

By Passing the Coulmn header name which is recivied by the function I need to make a math function over the data from this colum.

 

Initally I wanted to use a Query :

 

= let
Source = @#"Table",
ColumnName = #"Dynamic_ColumnName",
#"Added Conditional Column" = Table.AddColumn(Source, "Test Score", each if ColumnName <> "" then ColumnName/12 else null)
in
#"Added Conditional Column"

 

 

but I see in the reference there is only Column Header Name provided instead values so I'm getting error:

 

We cannot apply operator / to types Text and Number

 

Any suggestions ? Thank you.

1 REPLY 1
jbwtp
Memorable Member
Memorable Member

Hi @Trabka,

 

The ColumnName in your code seems to be type text not type number. Use something like Number.From(ColumnName)/12 to fix it.

 

Cheers,

John

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.

Top Solution Authors
Top Kudoed Authors