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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
msksenthil
Helper III
Helper III

M code - Functions: type Function to number

Friends, I try to call one function in to the other kind of nested.

 

M-Code:

let

ADD = (x as any) => let s2 = x+1
in
s2,

SUB = let s33 = ADD -1
in
s33
in
SUB

 

ERROR:

msksenthil_0-1621437641905.png

 

Thanks in advance

 

7 REPLIES 7
msksenthil
Helper III
Helper III

@Greg_Deckler @Anonymous Many thanks both of you. The below code is working fine to me

 

let

ADD = (x as any) => let s2 = x+4
in
s2,

SUB =(x as any) => let s33 = ADD(x) -3
in
s33
in
SUB

Greg_Deckler
Community Champion
Community Champion

@msksenthil I would still do it as 2 functions:

 

let
ADD = (x as any) => let s2 = x+1
in
s2
in
ADD



let
SUB = (x as any) => let s33 = ADD(x)-1
in
s33
in
SUB

 



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

You need to complete your ADD function. After you have in s2 , you have to write in ADD. right now, ADD is unevaluated function -1. 

Greg_Deckler
Community Champion
Community Champion

@msksenthil Perhaps I'm mistaken but don't you want 2 separate functions:

 

let
ADD = (x as any) => let s2 = x+1
in
s2
in
ADD



let
SUB = (x as any) => let s33 = x+1
in
s33
in
SUB

 



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Nope, I try to use the result of the previous 'let' in the following 'let'

Anonymous
Not applicable

Instead of "in s2", try "in s2 in ADD".

--Nate

Sorry, I didn't get you

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Kudoed Authors