So I use pivot table to display two dimensions and value. User want to have a new requirement, they want a variable to store as start DateKey and they can change it manually. If user type in 201904, then the value from 201901 to 201903 will apply for another logic and I want to check the current column whether equals to the type in value,
Variable name: CurrentMonth
If("=Right(LT.Month,2)-$(=CurrentMonth)" = 0, xxx,xxx) but it doesn't work.