udf
3 TopicsGeneric Commentary Framework for Power BI using Fabric UDF and DB
praful p invited you to a Microsoft Teams Meeting: Generic Commentary Framework for Power BI using Fabric UDF and DB Sunday, August 2, 2026 12:00 PM - 1:30 PM (IST) Meeting link: Generic Commentary Framework for Power BI using Fabric UDF and DB | Microsoft Teams | Meetup-Join About the Event: Are you looking for a robust, scalable way to integrate dynamic user write-backs and text commentary directly into your analytical reports? Join us for this deep-dive technical meetup where we will unveil a Generic Commentary Framework for Power BI using Fabric User-Defined Functions (UDFs) and Databricks. In this session, we will explore how to bridge the gap between read-only business intelligence and write-back functionality using a modern, low-latency data architecture. We will walk through the implementation of a Transanalytical Task Flow—a design pattern that seamlessly unifies transactional updates (capturing user comments) with analytical workloads (instantly reflecting those updates in Power BI dashboards) without compromising performance. What we will cover: --Architecture:During the event, we will cover the end-to-end architecture of the Commentary Framework using Microsoft Fabric, Databricks, and Power BI. ---Fabric UDF:We will discuss leveraging Custom/User-Defined Functions within the Fabric ecosystem to process and route text data efficiently, ----Databricks Integration:how Databricks orchestrates data transformations and manages the underlying data tier. -----Transanalytical Task Flows:You will also learn about balancing operational updates and fast analytical queries seamlessly using Transanalytical Task Flows, ------Live Demo: A live demo showing a practical walkthrough of a user entering data or commentary and seeing it flow straight into a Power BI visual in near real-time. This session is designed for: Data Architects & Solutions Architects Power BI Developers & Fabric Users Data Engineers working with Databricks Analytics Managers looking to implement write-back capabilitiesWould you like to know a secret way to delete your DAX UDF code?
🧠 Imagine you've written a brilliant DAX UDF in model view. Finally you decide to add a comment, and suddenly the whole function disappears. 'Undo' is not working. 🚨This happened to me a few days ago. It was my fault for trying to add a comment with "//" above the function header. However, I hadn't expected this to delete the entire function. 💡As I discovered, the problem isn't the comment itself, but characters that aren't allowed in a function name. After(!) deleting the function Power BI displayed a warning : "Special characters are not allowed in a function name..." That put me on the right track. Step-by-step guide to follow: ➡️ Write a DAX UDF in the model view (don't spend to much time on it, as your work will get lost) ➡️ Go to the top of the file ➡️ Press Shift-Enter ➡️ Go back to the top ➡️ Type "// Comment" or any other character that is not allowed in a function name ➡️ Press Enter to save your function ➡️ Is your function still there? ➡️ If not, check wether undoing (Ctrl-Z) works ❓ Is this a bug or a hidden feature? If it is a feature what is it good for? To permanentely delete my work? 🤔 ✒️ I look forward to your comments!557Views6likes2CommentsDAXUDF Reference a column
So, i want to make a DAX UDF that takes a (one-column) table as input and outputs a concatenation of all distinct values. Something like: DEFINE FUNCTION ConcValues = (column: Table) => CONCATENATEX( DISTINCT(column), ???columnName???, ", ") Since i can pass any table, the column name is variable and cannot be hard-coded in the UDF. Any ideas how to implement this? How to make a reference to a column name? Or how to reference the column of a table by a number, i.e. the 2nd column of the table or the first column, etc)Solved1.2KViews1like3Comments