Here is an example that shows how to compare two date values to filter the result using the Filter() function. In this scenario we want to find out of all the orders received this month how many were delivered on the same month. To do so we filtering on the month of [Delivery Date] that matches the current month as in the following Same Month Delivery calculated measure:
(
Filter( [Delivery Date].[Calendar].[Month].Members, [Delivery Date].[Calendar].CurrentMember.Name = [Date.Month Name].CurrentMember.Name ).item(0).Item(0),
[Measures].[Order Count]
)
0 Comments