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
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Dear vanessafvg,
thanks for your answer.

Can You guid me  how I can create date table  in  power  bi and  where I can paste Script ?

 

Best Regards, 

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