Forum Discussion

nev's avatar
nev
Frequent Visitor
9 years ago

Calculate using PriorYear but dont display future

I have a chart that displays monthly values, then a comparison bar from the same period last year, It uses the following formula to get the prior year: Prior Year Revenue = CALCULATE(SUM('V_AU ALR ...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi nev,

 

What is your sample data?

 

Regards,

Yuliana Gu

nev's avatar
nev
Frequent Visitor
9 years ago

Sorry, I don't have sample data, only production data from their live system which I cannot share.