Creating a DAX Calculated Column for Today, Yesterday and Next Working Day with Variables
Below was a question from the Power BI Community where the output was to have a calculated column in the Date Table, which would have Today for Todays date, Yesterday for Yesterdays Date, and Next Working Day (Being the following Monday) The challenge was that for the “Next Working Day” it should only be for the next Monday and not…
DAX, Power BI
2
Power BI – Why creating columns in the Query Editor is better, quicker and more efficient than creating Calculated Columns.
I have been reading and helping out where I can on the Power BI Community forums. And what I often see is people trying to use the Calculated Columns in the Power BI Desktop Model. So in this blog post below I am going to explain why it is better, quicker and more efficient to use the Query Editor to create additional columns….
Recent Posts
Tags
Azure
Azure Analysis Services
BI-NSIGHT
BI-RoundUp
Dataflows
DAX
Microsoft Fabric
Power BI
Power BI Premium
Power BI Premium Per User
Power BI RoundUp
Power Query
Power Query
SQL Server 2014
SQL Server Analysis Services
SQL Server Analysis Services Tabular
SQL Server Reporting Services
SSAS
Tabular Editor
Teams
Uncategorized