Forum Discussion

Twister8's avatar
Twister8
Helper II
9 years ago

Previous YEAR vs Selected Year

Hi guys,   Please help with this DAX   I need show the value by select YEAR vs PREVIOUS YEAR   I am using this expression:   Max Year = CALCULATE(SUM(MyTable[REAL]); FILTER ('TIMEDIM'; TIMEDI...
abhi123's avatar
abhi123
Frequent Visitor
9 years ago

Not getting you properly but i have done something as below.

 

I have used few calculation one is for current year real value and the last year real value as below

 

Last Year Real value = IF(YEAR('Table name'[Date Field])=YEAR(NOW())-1 , 'Table name'[Real value])

 

Current Year Real value = IF(YEAR('Table name'[Date Field])=YEAR(NOW()),'Table name'[Real value])

 

 

 

I thnik you should attach your pbix so that i can have more idea and give you the best i can.

 

Thanks 

Abhi.