Forum Discussion

chrisrobaciu's avatar
chrisrobaciu
Frequent Visitor
4 years ago

DateAdd problem with Quarter

Hello,   I have a weird problem which has been perplexing me for a couple of days:   I am trying to compare two (balance sheet) values over two periods based on the quarter end period that I sele...
Need Help
amitchandak's avatar
amitchandak
Super User
4 years ago

chrisrobaciu , Only use date

 

CALCULATE('BS Measures'[BS Actuals],DATEADD(ENDOFQUARTER('Calendar'[Date]),-1,QUARTER)))

 

or

 

CALCULATE([BS Actuals],DATEADD(('Calendar'[Date]),-1,QUARTER)))

chrisrobaciu's avatar
chrisrobaciu
Frequent Visitor
4 years ago

Hello amitchandak , thank you for your quick reply and your help.

Unfortunately that didn't fix the issue that I have. When I change to date, it keeps the problem but introduces another problem (it removes the cumulative-to-date aspect of the comparative period).