I have a table-Tbl1 with Multiple Rows of data by [Date] for a Column Item
I would like to make a Report or Newtable-Tbl2 with the last know data for that Column Item
I am adding new records every day to this table
Thanks for your help
Solved! Go to Solution.
Thanks Steve.
I changed _ROWNUMBER to “Date”…Thanks to @Marc_Dillon
SOLVED
([_THISROW] = MAXROW(“Well Tests”, “Date”, ([_THISROW].[Well Name] = [Well Name])))
I understand MaxROW()
I created a slice as Table and tried using MAXROW() function.
The MAXROW() expression does not work with a slice
How do I go about using Maxrow?
A slice is actually easier. Use a row filter expression like this:
(MAX(Tbl1[_ROWNUMBER]) = [_ROWNUMBER])
I have the Table with ID, Date, O, W,G
It has several rows with same ID, but the Date is different for each row.
The Date can be same for different ID.
I want to get the last entry for each ID
I used the Filter (MAX(Well Tests[_ROWNUMBER]) = [_ROWNUMBER])
It only gives me 1 ID and not for the last date that ID has data, but the last row the table.
I read this MAXROW(“Events”, “Date”, ([Date] < DATE(“1/1/” & YEAR(TODAY()))))…returns the row for the most recent event prior to this year
I want the table only the LATEST ENTRY of ID
Table Name: Well Tests
Column Headings:
|UniqueID|Well Name|API|Section|Date|Oil|Gas|Water|Hours On|%|SITP|SICP|FTP|FCP|24hr Oil|24hr Gas|24hr Water|Choke|Test Method|Allocate?|Notes|
Thanks
Amol!
Try:
([_THISROW] = MAXROW("Tbl1", "_ROWNUMBER", ([_THISROW].[ID] = [ID])))
i tried mimicing this
Replace ID
with whatever you were referring to with “ID” in the above.
ID was “Well Name”
It still gives me multiple rows of same Well Name
([_THISROW] = MAXROW(“Well Tests”, “_ROWNUMBER”, ([_THISROW].[Well Name] = [Well Name])))
Let’s try this, then:
([key-column] = MAXROW(“Well Tests”, “_ROWNUMBER”, ([_THISROW].[Well Name] = [Well Name])))
replacing key-column
with the name of the key column for the Tbl1 table.
I tested again, the last one before this _THISROW solution works better
Thanks for your very kind help.
([_THISROW] = MAXROW(“Well Tests”, “_ROWNUMBER”, ([_THISROW].[Well Name] = [Well Name])))
This gives me LastROW.
Would like to get the most recent well test, based on Date.
Thanks,
Amol
I encourage you to read the MAXROW() documentation I posted earlier in the thread. You requirement can be met with a small change in the expression.
Thanks Steve.
I changed _ROWNUMBER to “Date”…Thanks to @Marc_Dillon
SOLVED
([_THISROW] = MAXROW(“Well Tests”, “Date”, ([_THISROW].[Well Name] = [Well Name])))
I was really hoping this MAXROW expression of mine would work for a slice I am using simply to display the most recent office hour…
MAXROW(“Office Hours”, “_RowNumber”, [kot]=USEREMAIL())
[kot] refers to manager (name) key being email…
it check outs in expression but doesn’t work for the slice, i tried all sorts of variations but … this should work in my mind!
…we have one table of Office Hours, I want the most recent entry for the current user
Try using the form in the topic’s solution:
YESSSS SIRR!!!
Hi Steve
How can I get data only for EOMONTH()
Thanks Buddy!
You are a trooper
Regards,
Amol
I don’t understand. Please elaborate.
Thanks Steve
I am going to write another question, since its not related to this Table.
Thanks
Amol
The answer in MAXROW is “True” or “false”. How do I get the selected coloumn value of the last row in the table there? This is my equation. I applied this to the initial value. The answer is false.
[_THISROW] = MAXROW(“stock pile”, “_ROWNUMBER”,([_THISROW].[Stockpile No] = [Stockpile No]))
Can you help me?
Great. Fantastic:+1:
Dear sir, I have a table called as Patient Monitoring. I have created an application in which a care giver visits customers and logs details , I want to display the date of the last record that he entered for this one particular customer. I have been using this forumula
LOOKUP( MAX( SELECT( Patient Monitoring[_ROWNUMBER], ([_THISROW].[Phone Number] = [Phone Number]) ) ), "Patient Monitoring", "_ROWNUMBER", "Current Visit Date")
I tried and get an error
EXPRESSION ASSISTANT
([_THISROW] = MAXROW(“Well Tests”, “_ROWNUMBER”, ([_THISROW].[ID] = [ID])))
Error in expression ‘[_ComputedKey].[ID]’ : Unable to find column ‘ID’
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |