Week Commencing Error in Dax Formula

[Anonymous]

Hi Experts

Kindly refer to DimDate Table and Visual in First Tab. I am Getting two lots of week commencing values in my table visualsartion...Cannot see why and where the error is..

Sees Sample file

https://www.dropbox.com/s/0uyn8c6feqra1bs/Test_.pbix?dl=0 

[amitchandak · Accepted solution]

@Anonymous , Correct lastest month like

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

And all three measures like this example

Crim =
VAR LatestMonthSum =
CALCULATE ( SUM ( 'Test Data_'[cr03a_reportsmade] ),'Test Data_'[IsCurrentYear] = TRUE() ,
FILTER(
'Test Data_',eomonth('Test Data_'[cr03a_period],0)
=[Latest Month]
)
)

Return

[Anonymous]

Solved it not to worry - thanks once again

[Anonymous]

Still getting double week commencing values test it for yourself.