Forum Discussion
Converting the invoked function to Static Data for consolidation
Hi Anonymous ,
it sounds to me as if you're looking for what's often called as "incremental refresh".
I've published some workarounds here: How to create a Load History or Load Log in Power Query or Power BI – The BIccountantor here: Create a load history or stage in CDS instead of incremental load in Power BI – The BIccountant
But it's all a bit hacky, as you'll see.
With regards to a function that returns a static value. This is possible, but I question the motivation for it: Why not simply reference the static value?
Anyway: To do this you create a function without a parameter like so:() => let Source = #table({"Product", "Amount"}, {{"A", 10}, {"B", 20}}) in Source
Community ChampionHi Anonymous ,
it sounds to me as if you're looking for what's often called as "incremental refresh".
I've published some workarounds here: How to create a Load History or Load Log in Power Query or Power BI – The BIccountant
or here: Create a load history or stage in CDS instead of incremental load in Power BI – The BIccountant
But it's all a bit hacky, as you'll see.
With regards to a function that returns a static value. This is possible, but I question the motivation for it: Why not simply reference the static value?
Anyway: To do this you create a function without a parameter like so:
() =>
let
Source = #table({"Product", "Amount"}, {{"A", 10}, {"B", 20}})
in
Source