cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

DAX statement with Dates in Period not yielding correct results

Can someone tell me the error in this DAX?

It does not yield the correct sum of values in the datesinperiod function

 

TermCnt1YR =
    CALCULATE (
    SUM ( FactTermsActive[TermCnt]),
    FILTER ( FactTermsActive, FactTermsActive[EMPStatus] = "Terminated" ) ,
    FILTER ( FactTermsActive, DATESINPERIOD(FactTermsActive[TerminationDate], Today(),-365,DAY) )    )
1 REPLY 1
nmck86 Member
Member

Re: DAX statement with Dates in Period not yielding correct results

Hello! can you share a sample report with the expected output vs the output received?