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: genera...

I am developing an Aging Balance Report where I need to retrieve the last date of the month for previous months, but need to retrieve the most current day value in the current month. The great news is: I have been able to retrieve the last date for t...

I have a formula where I have to first find the max and min dates within a month against the data, then use those values to summarize dollars figures. I have measures that return the max and min dates. Works great. Within a subsequent measure, use th...