Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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()))
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.
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
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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
92 | |
82 | |
71 | |
49 |
User | Count |
---|---|
143 | |
121 | |
112 | |
58 | |
57 |