Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

sum with filters

 Hi, 

I Need Help

I want to apply this  sql query in Power bi  DAX 

SQL  = select SUM(Account_Balance_eq) FROM DepDepositHistory WHERE Date_Acount = '2000-12-31'

Need Help

4 Replies

  • Drors's avatar
    Drors
    Icon for Resolver III rankResolver III
    8 years ago

    MyMeasure = CALCULATE( sum( TableName[Account_Balance_eq]),TableName[Date_Acount ] = Date(2000,12,31))

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Thanks Dear Drors,

       

      I try your  answer but, the resulte in  the sql query not the sam Dax Measure, so I show for  you the  original Query  in sql

      please see this original querty

       

      DECLARE @DATE  AS DATETIME SET @DATE='2000-12-03'

      select SUM(Account_Balance_eq) FROM DepDepositHistory WHERE As_Of_Date=dateadd(DD, -1, dateadd(YY,datediff(yy,0,@DATE),0))

       

      Regards , 

      • Drors's avatar
        Drors
        Icon for Resolver III rankResolver III
        8 years ago

        That measure should give you the desired output, I think you didnt wrote the right date.

        check if its the correct date in the SQL query, you can write 

         

        DECLARE @DATE  AS DATETIME SET @DATE='2000-12-03'

        select As_Of_Date as MyDate FROM DepDepositHistory WHERE As_Of_Date=dateadd(DD, -1, dateadd(YY,datediff(yy,0,@DATE),0))

         

        and then check if its the same date as in your original post