i want to display to KPI's.
First is sales of current month and second is Sales of previous month. Everything should work dynamic linked to the selected month in the filter pane.
Do i have to do something in advance?
All you need is a date field and you can create month using the date field like below
Month(Date) as Month
then use the Month in set analysis for current month like below
In your load script crate the month field
and previous month in a chart expression like this
Share some sample data to replicate this