Forum Discussion
vividarinda
Helper II
2 years agoDax Count Row Number Over Partition on Power BI
Hello,
I am trying to convert the SQL stetment to DAX
SELECT COUNT(*) as totalrow from (
select DW."DW_FILTER_CUT_TRANSPOSE".*, row_number() over(partition by unitno,attribute order by sampledate desc) as rn from "DW_FILTER_CUT_TRANSPOSE"
) tt
where rn = 1
2 Replies
- amitchandak
Super User
vividarinda , We have rownumber function in DAX now
Power BI - New DAX Function: Rownumber- https://www.youtube.com/watch?v=yS9-IQjUDwg&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L&index=1
- vividarinda
Helper II
Thank you so much amitchandak . Your solution works fine