PREVIOUS MONTH TOTAL WITH FILTER CONDITION

[Anonymous]

Hi All,

I want to calculate Measure count of ID for dynamic previous month. With filter condition.

Requirment: Now its May 2021, I need to calculate count of April 2021. 

Count of ID where type = "Semi" & "Complete"  and Status = "Approved".

Here is my data

[FrankAT · Accepted solution]

Hi @Anonymous ,

take a look at the following solution:

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)