Exclude first item

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!

image

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