Filtering within a measure

I would like to know the best way to approach this business case.
I currently have a view where I am displaying information for a specific Year and Month. I have created a measure that references a value from another view. (see below)
measure: generalsum_inv_ei {
label: “General Sum - Invoice”
type: sum
filters: [collections_document_view.itemtype: “Invoice”]
sql:
${collections_document_view.openbalance};;
value_format_name: usd
}
Sticking Point: I would like to apply the Year Month in the current row as a filter in the measure.
How can I do this? I’ve tried a few ways with no avail.
Thank You,
Tim

0 1 100
1 REPLY 1

I switch to a measure and followed the sql block documentation.
All good

Top Labels in this Space
Top Solution Authors