Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
I have these columns in my data source and I'm trying to view the document that contains the most recent update.
Ex: I have a document DOCID = 1 And I want to bring the one with the most recent update date, for each different company. How could you do that in power bi?
Thanks to anyone who can help
how is it
how I want it to be
Solved! Go to Solution.
@Anonymous , Use this for date updated in a visual table
New measure for last update date =
calculate(max(Table[dateupdated]), filter(Table, Table[Date] = calculate(max(Table[dateupdated]), allexcept(Table, Table[Comapny], Table[Doc ID]))))
if needed use similar formula for other columns other than Doc ID and Company
@Anonymous , Use this for date updated in a visual table
New measure for last update date =
calculate(max(Table[dateupdated]), filter(Table, Table[Date] = calculate(max(Table[dateupdated]), allexcept(Table, Table[Comapny], Table[Doc ID]))))
if needed use similar formula for other columns other than Doc ID and Company
User | Count |
---|---|
25 | |
12 | |
8 | |
7 | |
7 |
User | Count |
---|---|
25 | |
12 | |
11 | |
10 | |
6 |