Need help in How to fetch the prior month property ID count

[Saichebrolu]

PropertyID	Created Date	MAXdate of id by month
ABC	7/20/2023	7/20/2023
ABC	7/19/2023
ABC	6/15/2023	6/15/2023
XYZ	5/12/2023
XYZ	5/20/2023	5/20/2023
XYZ	6/10/2023	6/10/2023
XYZ	7/1/2023	7/1/2023

Hello Community, Need help
i have a above table with Propertyid,Createddate.
By using those 2 columns i have created a calculated column that will return the max creatd date of each property id.
Now if i apply count on the [MAXdate of id by month]
count([MAXdate of id by month])= We get 5
>>if we select june month in the month slicer we get count 2
ie. 

ABC 6/15/2023 6/15/2023

XYZ 6/10/2023 6/10/2023
>>if we select july month in the month slicer we get count 2

ABC 7/20/2023 7/20/2023

XYZ 7/1/2023
7/1/2023

According to our table data present till the july month.
Myrequirment: if i select any month after the july in 2023 i should get the count of july month. how to achive this.
either August,September,October....December.


Need help

Thanks.

[rubayatyasmin · Accepted solution]

Hi, @Saichebrolu 

You can achieve this by creating a measure that checks the maximum date in your dataset against the selected month. 

for example: meas1 =  MAX(table[creat date])

then extract month from meas1.  like: MONTH([meas1])

then Create a measure for the selected month in the slicer

SelectedMonth = MONTH(MAX('TableName'[Created Date]))

lastly, create a measure that will give you the count based on the conditions you provided:

DesiredCount =
IF(
[SelectedMonth] <= [MaxDateMonth],
COUNT('TableName'[MAXdate of id by month]),
CALCULATE(
COUNT('TableName'[MAXdate of id by month]),
FILTER(
'TableName',
MONTH('TableName'[Created Date]) = [MaxDateMonth]
)
)
)

something like this.

Hope that helps.