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

Recursive Functions in online versions of Power Query

I have a recursive power query custom function that works as expected in Power BI desktop.  When I try to use the same M code as part of creating a dataflow or datamart I receive an error message stating "Expression.Error: A cyclic reference was encountered during evaluation."  Are recursive functions not supported in the online versions of power query?

 

For reference the function is below where date is a scalar date value and holidays is a list of dates.

******************************************

let
    Source = (date as date,holidays as list) =>
   
    let
    adjusted_date =
   
        if Date.DayOfWeek(date)=0
        then Date.AddDays(date,1)
        else if Date.DayOfWeek(date)=5 then Date.AddDays(date,3)
        else if Date.DayOfWeek(date)=6 then Date.AddDays(date,2)
        else Date.AddDays(date,1)
    ,
   
holiday_adjusted=
    if List.Contains(holidays,adjusted_date) then @liquidity_date(adjusted_date,holidays)
    else adjusted_date
in  
    holiday_adjusted
in
    Source

 

 

 

1 ACCEPTED SOLUTION
artemus
Microsoft Employee
Microsoft Employee

This appears to be mostly a visual bug, you can still invoke the function as normal. You can also wrap it in a 

let liquidity_date_fn = <code> in liquidity_date_fn

and just use @liquidity_date_fn when you call the function

View solution in original post

2 REPLIES 2
artemus
Microsoft Employee
Microsoft Employee

This appears to be mostly a visual bug, you can still invoke the function as normal. You can also wrap it in a 

let liquidity_date_fn = <code> in liquidity_date_fn

and just use @liquidity_date_fn when you call the function

This works.  Thank 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