SQLBI

This article/video describes how to define optional parameters in DAX user-defined functions and set default values for parameters not specified by the caller. #dax #powerbi #udf

ALL, ALLSELECTED, ALLEXCEPT, and REMOVEFILTERS: There are several DAX functions to remove filters from the filter context. In this article + video, we analyze the differences among them and clarify what to use depending on the requirements. #dax #powerbi

This article+video describes the new Expression Context property for calculated columns in Power BI, explaining how 𝘂𝘀𝗲𝗿-𝗮𝘄𝗮𝗿𝗲 𝗰𝗮𝗹𝗰𝘂𝗹𝗮𝘁𝗲𝗱 𝗰𝗼𝗹𝘂𝗺𝗻𝘀 work, why they are not materialized, and how to use them as 𝘃𝗶𝗿𝘁𝘂𝗮𝗹 𝗰𝗮𝗹𝗰𝘂𝗹𝗮𝘁𝗲𝗱 𝗰𝗼𝗹𝘂𝗺𝗻𝘀 for localization and custom security scenarios. #powerbi #dax

A slicer cannot filter a measure. This article+video analyzes this common request by explaining how to use a slicer to filter a measure, after discussing the real meaning of using a measure with a slicer. #powerbi #dax

If you are in Switzerland or need a good excuse to visit, Marco Russo will teach 𝗠𝗮𝘀𝘁𝗲𝗿𝗶𝗻𝗴 𝗗𝗔𝗫 𝗶𝗻 𝗭𝘂𝗿𝗶𝗰𝗵 𝗼𝗻 𝗝𝘂𝗻𝗲 𝟭𝟬-𝟭𝟮, 𝟮𝟬𝟮𝟲. Level up your DAX skills, also learning the 𝗹𝗮𝘁𝗲𝘀𝘁 𝗳𝗲𝗮𝘁𝘂𝗿𝗲𝘀: User-defined functions (UDFs), calendar-based time intelligence, and, of course, all the other topics covered in the latest book and video course (which are included for all students of the in-person course). The 𝘁𝗿𝗮𝗶𝗻𝗶𝗻𝗴 𝗹𝗼𝗰𝗮𝘁𝗶𝗼𝗻 is literally 𝗮𝘁 𝘁𝗵𝗲 𝗮𝗶𝗿𝗽𝗼𝗿𝘁, so it is also very convenient if you have a direct flight to Zurich! 𝗝𝘂𝗻𝗲 𝟭𝟬-𝟭𝟮, 𝟮𝟬𝟮𝟲 𝗭𝘂̈𝗿𝗶𝗰𝗵, 𝗖𝗛 https://lnkd.in/ePf_2SaN If you cannot attend the training but you are in the area, do not miss Marco's free evening session at the Zürich Fabric User Group on June 11 at 5 pm:

This article+video describes the parameter types available in DAX user-defined functions, focusing on the specialized reference types MEASUREREF, COLUMNREF, TABLEREF, and CALENDARREF. #dax #powerbi

Visual calculations can be used efficiently to format visuals. This article and video present an interesting technique to highlight a row based solely on the maximum value in the last column. https://lnkd.in/djs6kuah #powerbi #dax

We recorded an unplugged session to talk about the third edition of the 𝗠𝗮𝘀𝘁𝗲𝗿𝗶𝗻𝗴 𝗗𝗔𝗫 𝗩𝗶𝗱𝗲𝗼 𝗖𝗼𝘂𝗿𝘀𝗲: what changed, what is new, and a few behind-the-scenes moments. Quick recap on the blog, full video in the post.

Should you use DAX user-defined functions (UDFs) or calculation groups? The question is legit; the answer is that both have a role. For years, we used calculation groups as a surrogate for functions. But now that we have the real thing, we can use both, each one in the right place. Video and article:  https://lnkd.in/dZQ4FEvy #powerbi #dax #udf

The 𝘁𝗵𝗶𝗿𝗱 𝗲𝗱𝗶𝘁𝗶𝗼𝗻 of the 𝗠𝗮𝘀𝘁𝗲𝗿𝗶𝗻𝗴 𝗗𝗔𝗫 𝘃𝗶𝗱𝗲𝗼 course is 𝗮𝘃𝗮𝗶𝗹𝗮𝗯𝗹𝗲! - new features: UDFs, calendars, visual calcs - smoother learning path - launch offer available until April 3 All the existing students of the Mastering DAX video course (second edition) have been automatically upgraded for free. Read more details in the official announcement!