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

Shapiyev, Grisha 6 Reputation points
2021-12-07T14:42:19.74+00:00

Hello,

Got into a small problem. In tabular model in SSAS (ver 15.0.35.15) 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
    2021-12-08T13:06:57.85+00:00

    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
    2021-12-10T06:52:10.997+00:00

    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.
    156518-screenshot-2021-12-10-144905.png

    Best regards,
    Carrin


    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.