I have fact table which consists of Monthid Column as Integer which direct connect to date dimension
Productid MaterialId monthid Balance
1 1 1 100
1 1 2 200
Requiremnet is as below:
I have two slicers one is for current month and another one is for previous month
lets say currentmonth is feb2020 and previousmonth i selected as dec2019 i want to show diff of balances for feb2020 and dec2019 and thier cumulative totals
My question:
How to achive currentmonth and previous month when the date are integers in power bi and what is the soluion for the above scenario.kindly do needful