I tried to have calculations of difference between two months in two years in the pivot table from power pivot. I've done some research but couldn't find a way to solve my purpose. Unfortunately, the Power BI is not available only Power Pivot and Power Query.
I remember previously in Pivot Table i could do calculated fields but not in this one they are greyed out.
So, i need the columns of Var FY21-Fy20 and Var % from Pivot. Not sure if this is doable. For now, i can only think to manually copy out the data and add the 2 columns.
I remember previously in Pivot Table i could do calculated fields but not in this one they are greyed out.
So, i need the columns of Var FY21-Fy20 and Var % from Pivot. Not sure if this is doable. For now, i can only think to manually copy out the data and add the 2 columns.