Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Dear All,
I would like to display the recent dollar price from the table for each country there are 240 countries,
I have added a column with mention below DAX
Solved! Go to Solution.
Give this a shot
RDP = MINX ( TOPN ( 1, FILTER ( 'Dollar Data', 'Dollar Data'[Country_Code] = EARLIER ( 'Dollar Data'[Country_Code] ) ), 'Dollar Data'[Date], DESC ), 'Dollar Data'[dollar_price] )
Give this a shot
RDP = MINX ( TOPN ( 1, FILTER ( 'Dollar Data', 'Dollar Data'[Country_Code] = EARLIER ( 'Dollar Data'[Country_Code] ) ), 'Dollar Data'[Date], DESC ), 'Dollar Data'[dollar_price] )
Thank you Zubair,
This is indeed a great help, there will be more queries may i post them onto the forum.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |