Previous Month Reports Error in DAX

[Anonymous]

Hi Experts

Here are my measures in order to calculate the previous months reports... but i am getting zero... when i have values for the previous month in the data set...

Crime Report PM LM =
VAR LatestMonthSum =
CALCULATE ( SUM ( 'Test Data_'[cr03a_reportsmade] ),'Test Data_'[IsCurrentYear] = TRUE (),
FILTER(
'Test Data_',eomonth('Test Data_'[cr03a_period],0)
=[Latest Month] -1
)
)

Return
LatestMonthSum

Where 

Latest Month = eomonth(maxx(allselected('DimDate'), 'DimDate'[Date]),0)

[amitchandak]

@Anonymous , you are using 'Test Data_'[IsCurrentYear] = TRUE (), if the max month is an , then you will get null

You can check without that or try all on date

Crime Report PM LM =
VAR LatestMonthSum =
CALCULATE ( SUM ( 'Test Data_'[cr03a_reportsmade] ),
FILTER(
all('Test Data_'[cr03a_period]),eomonth('Test Data_'[cr03a_period],0)
=[Latest Month] -1 &&  'Test Data_'[IsCurrentYear] = TRUE ()
)
)

Return
LatestMonthSum

or

Crime Report PM LM =
VAR LatestMonthSum =
CALCULATE ( SUM ( 'Test Data_'[cr03a_reportsmade] ),
FILTER(
('Test Data_'[cr03a_period]),eomonth('Test Data_'[cr03a_period],0)
=[Latest Month] -1
)
)

Return
LatestMonthSum

[Anonymous]

Neither formula are working

[amitchandak]

@Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Anonymous]

Hi Amit - did you get a chance to have a look at the sample data and question

[Anonymous]

Hi Amit the sample PBIC has Feb 21 data....

[Anonymous]

https://www.dropbox.com/s/x1psmkq9jac59un/2021%200330%20%282%29.pbix?dl=0