How do I sort the referrenced column? I have another table which requires data from another table, I wanted the drop down list to appear the latest entry. How can I do this?
You can do that with the ORDERBY expression like ORDERBY(SELECT(TableName[KeyColumnName],TRUE),[TIMESTAMP],TRUE)
I placed it on the ref and showed error.
Would you please show that expression?
Where did you put this formula?
In the app formula box
Change it to Valid_If
Thanks it worked. one more question, I tried to make a slice with row filter. AND([Date of Admission]=Now()-1, [Time of Admission]>=“07:00:00”) added that expression but the value of 07:00:00 doesn’t seem to return as 7AM instead as 12/30/1899 7:00:00 AM")
That’s the day number 0. Is your slice working correctly?
not working properly, I tried to use the “TEST” Should have resulted as false
Is your column [Time of Admission] a real Time field?
extracted from Date of Admission