USERELATIONSHIP lets you temporarily change which relationship is active. Even though USERELATIONSHIP is easy to work with in measures, it can be challenging and give you inaccurate results when used in calculated columns. In this article, we describe the details of using USERELATIONSHIP in a calculated column.
Read more

Last week we released a big update to DAX Guide: almost every DAX function now has its own dedicated video on its own dedicated page! Each video introduces one or more new examples, which are also available in the related section on DAX Guide. If you want to try the sample code just click on TRY IT to play with the code in, the playground that we announced in the previous newsletter!
Watch announcement


Latest videos - Behind the scenes
23:44#unpluggedMarco Russo
Comment review: First day of sales
17:57#unpluggedAlberto Ferrari
Analyzing the performance of DISTINCTCOUNT in DAX
12:24Alberto Ferrari


Latest news
• Power BI Premium Per User pricing and availability
Microsoft has finally disclosed their pricing for Power BI Premium Per User: it is an additional US$10 per month for existing Power BI Pro or Microsoft 365 E5 users. The cost is US$20 per month for new users. Considering its features, additional capacity, and performance, it is a very good price – almost a no-brainer for small and medium companies. The new licensing will become generally available on April 2, 2021. Until then, it is available for free in preview.
Mar 2, 2021 · Microsoft
• Power BI Premium Gen2 autoscale preview
For companies using Power BI Premium with the capacity licensing, the autoscale feature for Gen 2 Premium capacities is now available in preview. More CPU for peak times, same memory – but in Gen 2 the memory is no longer as big a concern as it was in Gen 1.
Mar 3, 2021 · Microsoft
• Power BI embedded analytics playground
Developers interested in trying Power BI Embedded can now do so in an online playground with a developer sandbox and several examples. You can explore APIs, write your code, and see the result without having to install or configure anything. A very welcome tool from Microsoft.
Mar 1, 2021 · Microsoft
• Cost comparison between Azure Analysis Services and Power BI Premium Per User
With Power BI Premium Per User it is now cheaper to move certain Azure Analysis Services workloads over to Power BI. This blog post compares the licensing price between 10 and 500 users and the result is that most of the time, Azure Analysis Services is no longer convenient. Read the article to evaluate the "it depends" zone and do the math for specific scenarios.
Mar 9, 2021 · Martin Schoombee
• Tabular Editor 2.14.2
This is a minor update to Tabular Editor, which is important especially if you connect to Power BI Premium workspaces because of the update of the TOM libraries.
Mar 1, 2021 · Daniel Otykier
• SQLBI website updates
The SQLBI website was refreshed with a refined layout and refined fonts, a new video section and an improved search tool for articles and videos. Finding the DAX content you need should now be easier!
Feb 12, 2021 · SQLBI
DAX Patterns