Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi there,
How to retrieve a value based on the max date of another column which is mapped to multiple entries which in trur is mapped to a single value.
The question may be confusing. Pleae refer the below snap that would help.
This is my table. One IB name has many document name that has its date and companyname
.Now i want just the company name of the latest document name for the IBname. Pleae
Solved! Go to Solution.
Hey Thanks for your quick response. Your solution will work fine. But i did not want a fitler to arrive at the value.
Tried a simple measure finally. Surprisingly it worked fine.
No sure if this will help but you can create a column to use as a filter:
Hey Thanks for your quick response. Your solution will work fine. But i did not want a fitler to arrive at the value.
Tried a simple measure finally. Surprisingly it worked fine.
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |