Forum Discussion
Week Commencing Error in Dax Formula
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
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
3 Replies
- amitchandak
Super User
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