How to compare sales with last year and budget in same visual and kpi cards

[Anonymous]

Hi all,

I need your help  to  compare sales, GP, and GM in report with Last year sales and budget by just clicking the button. I have seen a video online but I did not fully understand how to do it.When I press Previous it should compare sales with last year sales and if I press target it should compare it with budget

[MattAllington · Accepted solution]

Have a read of my article here https://exceleratorbi.com.au/dax-time-intelligence-beginners/

also download my quick ref guide here to see all the available built in time intelligence functions you can use 

https://exceleratorbi.com.au/product/dax-reference-guide/

[Anonymous]

Thanks @MattAllington,

I understood about time intelligence function behaviour. But I did not unstand how to link this buttons ?