I need to convert this T/SQL in to DAX

[Abreham]

SELECT top 10 Column1,Column2 
FROM Table1
WHERE DATEPART(m, CreateDate) = DATEPART(m, DATEADD(m, -1, getdate()))
AND DATEPART(yyyy, CreateDate) = DATEPART(yyyy, DATEADD(m, -1, getdate()))

[v-xjiin-msft]

Hi @Abreham,

Something like:

Test =
TOPN (
    10,
    FILTER (
        'calendar',
        MONTH ( 'calendar'[Date] )
            = MONTH ( TODAY () ) - 1
            && YEAR ( 'calendar'[Date] )
                = YEAR ( TODAY () ) - 1
    ),
    'calendar'[Date]
)

Put it in a calculated table. And 'calendar' is just a calendar table: calendar = CALENDAR(DATE(2017,01,01),DATE(2018,12,31) ).

Reference: https://msdn.microsoft.com/en-us/query-bi/dax/topn-function-dax

Thanks,
Xi Jin.

[Abreham]

Thank you for replying. It's very close but it has an issue. I have remoed TOP from T/SQL. I just need  LastMonth record but it should be Dynamic.

 select Column1  from TableName

 WHERE DATEPART(m, ColumnFromTable) = DATEPART(m, DATEADD(m, -1, getdate()))
AND DATEPART(yyyy, ColumnFromTable) = DATEPART(yyyy, DATEADD(m, -1, getdate()))

Thanks 

[Greg_Deckler]

The DAX equivalents are:

SELECT top 10 => TOPN

DATEPART => MONTH, YEAR, DAY

DATEADD => DATEADD

getdate => TODAY, NOW, UTCTODAY, UTCNOW

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490