Hello everyone. Query about expressions.
I have two tables.
A table is of dates (read only), where the [Row Id] is the date itself since it is unrepeatable and unique. It has 4 fields.
[RowId], [Month] [Year] [Period]
The Month, Year, and Period values are calculated by themselves.
Month --> MONTH([DATE])
Year-->YEAR([DATE])
Period-->CONCATENATE(Month;"-";"Year")
Another table that is for salaries where there is a field called Period (Ref Type) and from where I want to be able to select a period from the dates table.
Use the following suggested value:
UNIQUE(
ORDERBY(
SELECT(
Dates[Period],TRUE()
),[Date]
)
)
But all the suggested values have a warning with an exclamation point.
The label, in the dates table, is Date.
Does anyone know how I can get that listing?
Thankyou
LinkedIn
Twitter
