Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

CONVERT SQL QUERY TO DAX Measure

Hi , Please Help me . I want to convert sql  qury into  DAX Measure    -----------SQL Query ------------------------- DECLARE @DATE AS DATETIME SET @DATE='200-12-03'   select SUM(Account_Balan...
Need Help
vanessafvg's avatar
vanessafvg
Community Champion
8 years ago

Anonymous into a blank page into power query

 

if you read the post i posted it gives you all the details, please read it

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Dear vanessafvg,

thanks alot ,
the creation of table done and make relation between date table and my Measure table , but the the resulte is wrong, please finde bellow iamges

  • vanessafvg's avatar
    vanessafvg
    Community Champion
    8 years ago

    Anonymous you might need to format your result, it usually displays like that when a number is to long, what is the data type?  can you show the result in a table to see the result properly

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      hi ,

      yes I format my resulte, but I want to show  the  same  number  in  sql qury ,like  the  query  in bellow  image  

      so  my problem only  how to  convsert where condition "inside blue line" form sql into Dax