SQL to DAX help required

[Anonymous]

Please help in converting below SQL query to DAX-

Select A.*,(Currentmonth-1) As PreviousMonth from ( select max([SeqID])AS Currentmonth
from [dbo].[CT]
where [Month]=1)A

[Anonymous]

I think you can directly write SQL query while pulling data into PowerBI from SQL. Go to Get Data>Select SQL Server Database> Select Import Data Connectivity mode> Expand Advanced Options and then write SQL Query. Do not forget to set time out time.