Difference in the behaviour for DAX DATE function in SSAS in Power BI

Shapiyev, Grisha 6 Reputation points


Got into a small problem. In tabular model in SSAS (ver we are using DATE function with negative parameters for month and day to get dates in the past without any problem.
We started getting problems with the same approach in power bi models and found out that DAX does not support negative values (https://learn.microsoft.com/en-us/dax/date-function-dax). Is DAX implementation different in both? Should we revisit our approach in SSAS before any upgrades to the server?

Thank you

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,237 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Shapiyev, Grisha 6 Reputation points

    I'm sorry. This is not an answer. I'm asking about different behaviour of DATE(Year, Month, Day) function in DAX implementation in SSAS Tabular and Power BI. In SSAS I can use negtive values for Month and Day parameters. In Power BI I cannot.

  2. CarrinWu-MSFT 6,841 Reputation points

    Hi @Shapiyev, Grisha ,

    I installed latest Power BI Desktop, and then tested your DAX which you provided, it works in my side. Maybe you should update your Power BI Desktop to latest version.

    Best regards,

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.