How to create DAX for below query from SQL

[Anonymous]

select MAX(SeqID) from [dbo].[CT]
where [MonthId]=1

Here, CT is a calendar table.

[az38 · Accepted solution]

Hi @Anonymous 

try this 

Measure = calculate(MAX(CT[SeqID]);CT[MonthId]=1)

[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

[Nathaniel_C · Accepted solution]

Hi @Anonymous ,

Try CALCULATE (MAX(CT[SeqID], CT[MonthID] = 1)

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

[az38 · Accepted solution]

Hi @Anonymous 

try this 

Measure = calculate(MAX(CT[SeqID]);CT[MonthId]=1)