Forum Discussion
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
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.