Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

convert sql to DAX query

 I have two tables billing Status , billing rate and billing information(Rate and information table table have relation ship) but Billing status table dont have any relationship becacuse its hardcoded value in ssrs. I am looking for dax function to convert bellow query.

 

IF @B.@Status = '1
BEGIN
SET Anonymous = Anonymous + @CRLF + 'AND AR.EFFECTIVE_DATE <= GETDATE() AND AR.TERMINATION_DATE >= GETDATE() ' + @CRLF
SET Anonymous = Anonymous + @CRLF + 'AND AC.EFFECTIVE_DATE <= GETDATE() AND AC.TERMINATION_DATE >= GETDATE() ' + @CRLF
END
IF @Billing_Status = '2'
BEGIN
SET Anonymous = Anonymous + @CRLF + 'AND AR.TERMINATION_DATE < GETDATE() ' + @CRLF
--SET Anonymous = Anonymous + @CRLF + 'OR AC.TERMINATION_DATE < GETDATE()) ' + @CRLF
END

Need Help
Tips and Tricks
Tutorial Requests

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    @Narayana3635 ,

    Could you please describe more about the above query? We would need to know what @CRLF,@SQL, AR, AC refer to in the above query.

    You can follow the instructions in this blog to share sample data of your tables and post expected result here.

    Regards,
    Lydia