Hi,
I am trying to exclude the first item in the filter. For example when i add “2021-01” in the Dimension “Month” pages filter, I would want the measure “test09990” to all show “2021-01”. Would appreciate your help, thanks!
Hi @whosiao,
You can use the following formula that will give the name of the first Month on rows:
Generate(
VisibleRowsSet(),
[Month].CurrentHierarchyMember
).Item(0).Name
Lauma / support@eazybi.com