Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
User | Count |
---|---|
132 | |
74 | |
70 | |
58 | |
54 |
User | Count |
---|---|
192 | |
96 | |
67 | |
64 | |
54 |