Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

SQL to DAX help required

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

SQL to DAX

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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.