convert sql to DAX query

[Anonymous]

 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

[Anonymous]

@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