Hello
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. i guess this is because it is coming from Data Model.
I would like the columns of Var FY21-Fy20 and Var % from Pivot. Not sure if this is doable.
FY21 and FY20 is stored in one column.
The actual numbers of December of each year is stored in the same numbers.
For now, i can only think to manually copy out the data and add the 2 columns.
PLease help!
Thanks
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. i guess this is because it is coming from Data Model.
I would like the columns of Var FY21-Fy20 and Var % from Pivot. Not sure if this is doable.
FY21 and FY20 is stored in one column.
The actual numbers of December of each year is stored in the same numbers.
For now, i can only think to manually copy out the data and add the 2 columns.
PLease help!
Thanks