Bernat Agulló
@agullobernat.bsky.social
Esbrina Partner and Microsoft Data Platform MVP
Power BI fanatic and data lover in general
If you are a Microsoft MVP please add bluesky to your MVP Profile too! #MVPbuzz
Power BI fanatic and data lover in general
If you are a Microsoft MVP please add bluesky to your MVP Profile too! #MVPbuzz
Pinned
Bernat Agulló
@agullobernat.bsky.social
· Oct 11
#powerbi #daxudf #csharp #tabulareditor #pbir #pbip | Bernat Agulló Roselló
New Blog Post! Now that we have DAX UDFs we can finally encapsulate repetitive logic to define axis max and min for example. But then again, creating all those visual calcs is quite boring isn't it?
...
www.linkedin.com
What if I told you it's possible to add dax udfs in your model specific to Visual Calcs, but not only that you can then go on and create those visual calcs using the dax udfs to achieve tool things, all in one (long) script? www.esbrina-ba.com/industrializ... #PowerBI #TabularEditor #PBIR
some #PowerQuery function anyone? github.com/bernatagullo...
PowerQuery/Comparisons/fxCompareLists at main · bernatagulloesbrina/PowerQuery
here I put functions I want to reuse. Contribute to bernatagulloesbrina/PowerQuery development by creating an account on GitHub.
github.com
November 14, 2025 at 11:02 AM
some #PowerQuery function anyone? github.com/bernatagullo...
November 13, 2025 at 1:09 PM
thank god there was a clarifying tooltip
November 1, 2025 at 10:12 PM
thank god there was a clarifying tooltip
Is this a dog? it's intentional as well?
October 31, 2025 at 2:23 PM
Is this a dog? it's intentional as well?
Tickets for PBIG bought!
October 30, 2025 at 10:46 AM
Tickets for PBIG bought!
need to copy conditional formatting between headers of a table in Power BI?
Say no more: github.com/bernatagullo...
Say no more: github.com/bernatagullo...
TabularEditor-Scripts/Advanced/Report Layer Macros/Copy Header Formatting between headers.csx at main · bernatagulloesbrina/TabularEditor-Scripts
Scripts for Tabular Editor 2 & 3. Community driven to make your Tabular Editor experience as fast as possible. - bernatagulloesbrina/TabularEditor-Scripts
github.com
October 23, 2025 at 9:50 AM
need to copy conditional formatting between headers of a table in Power BI?
Say no more: github.com/bernatagullo...
Say no more: github.com/bernatagullo...
So yeah, now the spinning wheel replaces the item icon, because, why not? I'm sure that before it's implemented in all artifacts this will change again
October 23, 2025 at 9:49 AM
So yeah, now the spinning wheel replaces the item icon, because, why not? I'm sure that before it's implemented in all artifacts this will change again
Remember when we complained about the iTunes updates because we had to download 150 MB ?
"Hold my beer" says Visual Studio...
"Hold my beer" says Visual Studio...
October 22, 2025 at 3:44 PM
Remember when we complained about the iTunes updates because we had to download 150 MB ?
"Hold my beer" says Visual Studio...
"Hold my beer" says Visual Studio...
the numbers are in:
October 21, 2025 at 12:39 PM
the numbers are in:
PSA: *Always* put your lakehouse name as a parameter
October 16, 2025 at 1:56 PM
PSA: *Always* put your lakehouse name as a parameter
so far not looking good for bluesky www.linkedin.com/feed/update/...
Let's see the numbers | Bernat Agulló Roselló
Let's see the numbers
www.linkedin.com
October 14, 2025 at 1:56 PM
so far not looking good for bluesky www.linkedin.com/feed/update/...
It's pretty sad that Power BI Weekly gets more engagement on X posting a link to my blog that I get posting the same link on Bluesky ...
October 13, 2025 at 9:19 PM
It's pretty sad that Power BI Weekly gets more engagement on X posting a link to my blog that I get posting the same link on Bluesky ...
this is getting out of hand
October 13, 2025 at 10:35 AM
this is getting out of hand
new customer has no power bi at all
October 13, 2025 at 10:34 AM
new customer has no power bi at all
@jaypowerbi.bsky.social can we get an SVG version of the DAX UDF icon? because of, things.
October 12, 2025 at 3:18 PM
@jaypowerbi.bsky.social can we get an SVG version of the DAX UDF icon? because of, things.
What if I told you it's possible to add dax udfs in your model specific to Visual Calcs, but not only that you can then go on and create those visual calcs using the dax udfs to achieve tool things, all in one (long) script? www.esbrina-ba.com/industrializ... #PowerBI #TabularEditor #PBIR
#powerbi #daxudf #csharp #tabulareditor #pbir #pbip | Bernat Agulló Roselló
New Blog Post! Now that we have DAX UDFs we can finally encapsulate repetitive logic to define axis max and min for example. But then again, creating all those visual calcs is quite boring isn't it?
...
www.linkedin.com
October 11, 2025 at 3:34 PM
What if I told you it's possible to add dax udfs in your model specific to Visual Calcs, but not only that you can then go on and create those visual calcs using the dax udfs to achieve tool things, all in one (long) script? www.esbrina-ba.com/industrializ... #PowerBI #TabularEditor #PBIR
just made a c# script that creates DAX UDFs to be used from Visual Calculations, but not only that it actually modifies a chart in the report adding a couple measures (hidden) 3 visual calcs using those new functions (hidden as well) and assigns the visual calcs to the max and min of the Y axis.
October 9, 2025 at 10:40 PM
just made a c# script that creates DAX UDFs to be used from Visual Calculations, but not only that it actually modifies a chart in the report adding a couple measures (hidden) 3 visual calcs using those new functions (hidden as well) and assigns the visual calcs to the max and min of the Y axis.
you gotta love PBIR... case sensitive and DAX must of course be spelled in lowercase because let's make the world burn #PowerBI #CSharp #TabularEditor #VisualCalcs
October 9, 2025 at 10:06 PM
you gotta love PBIR... case sensitive and DAX must of course be spelled in lowercase because let's make the world burn #PowerBI #CSharp #TabularEditor #VisualCalcs
the semantic model refresh activity has been fixed and you can now select the tables you want to refresh, again. Rejoice! #MicrosoftFabric #DataFactory
October 7, 2025 at 8:44 AM
the semantic model refresh activity has been fixed and you can now select the tables you want to refresh, again. Rejoice! #MicrosoftFabric #DataFactory
New Blog Post! Model-Independent DAX UDFs are great, but can we do something to automate those that are model-dependent? Yes we can! Like for calc groups, we can replicate the same logic modifying the little dependencies to make our functions work with our model! www.esbrina-ba.com/industrializ...
#daxudf #csharp | Bernat Agulló Roselló
New Blog Post! Continuing with #DAXUDF, I know all the rage is with model-independent functions in daxlib.org (which is great), but what about model-dependant functions? Like calculation groups, even ...
www.linkedin.com
October 4, 2025 at 1:38 PM
New Blog Post! Model-Independent DAX UDFs are great, but can we do something to automate those that are model-dependent? Yes we can! Like for calc groups, we can replicate the same logic modifying the little dependencies to make our functions work with our model! www.esbrina-ba.com/industrializ...
Can't wait!
We can't wait to take #FabConEurope to Barcelona next year ☀️
Bookmark Sep 28 - 1 Oct in your calendar now! Register you interest to be notified when 2026 tickets go on sale 👉 https://ow.ly/Ah1C50X4R5g
#MicrosoftFabric #FabCon
Bookmark Sep 28 - 1 Oct in your calendar now! Register you interest to be notified when 2026 tickets go on sale 👉 https://ow.ly/Ah1C50X4R5g
#MicrosoftFabric #FabCon
October 1, 2025 at 12:47 PM
Can't wait!
Yes! We are collaborating with @socestadistica.bsky.social to organize a large event (200pax approx) in a university campus. Looking forward to the success of the event 😊
El 20/10 serà el Dia Mundial de l’Estadística amb activitats a la UAB:
- Statistical Short Course. mat.uab.cat/web/mcs/stat...
- Workshops Power BI. mat.uab.cat/web/mcs/jorn...
- Power BI Days. mat.uab.cat/web/mcs/jorn...
- XXV Dia de l’Estadística. eformularis.uab.cat/ca/web/mcs/d...
- Statistical Short Course. mat.uab.cat/web/mcs/stat...
- Workshops Power BI. mat.uab.cat/web/mcs/jorn...
- Power BI Days. mat.uab.cat/web/mcs/jorn...
- XXV Dia de l’Estadística. eformularis.uab.cat/ca/web/mcs/d...
September 30, 2025 at 11:09 AM
Yes! We are collaborating with @socestadistica.bsky.social to organize a large event (200pax approx) in a university campus. Looking forward to the success of the event 😊
So you need to calculate absolute and percent differences all the time? These two functions will do this for you, plus are ready to use with my measure-generating macro! daxlib.org/package/Ever...
DAX Lib
daxlib.org
September 29, 2025 at 1:32 PM
So you need to calculate absolute and percent differences all the time? These two functions will do this for you, plus are ready to use with my measure-generating macro! daxlib.org/package/Ever...
I had to search on twitter for my own tweet as I could not recall any longer how to create the linq expression to get the list of fact tables in a perfect star schema model
September 28, 2025 at 12:58 PM
I had to search on twitter for my own tweet as I could not recall any longer how to create the linq expression to get the list of fact tables in a perfect star schema model
I did some major refactoring of the code as it was basically not working for functions with more than one parameter. I implemented the code for funtions that encapsulate the code for a DAX calculated column. If you try it let me know your experience.
New Blog Post! So you want to centralize code of your measures with #DAXUDF functions, but you don't want to manually create all your measures (and configure formatstring and so on and so forth)? Look no further! Check out my article & C# Script on the topic. www.esbrina-ba.com/automaticall...
Automatically create measures with DAX user-defined functions - Esbrina
DAX User-Defined Functions centralize code across expressions. A C# script and annotations on functions allow automatic creation of measures.
www.esbrina-ba.com
September 27, 2025 at 10:04 AM
I did some major refactoring of the code as it was basically not working for functions with more than one parameter. I implemented the code for funtions that encapsulate the code for a DAX calculated column. If you try it let me know your experience.