Forum Discussion
Solved
Copy up/down If Statement column
I wrote an if column statement on my calendar table that is working perfectly; however I need it to fill up/down on the column so I can write my next formula, [IsCurrentMonthCust2] <= [RollMonthCusto...
I figured it out. I changed the field to whole number and added a column and/or measure to sum the results. Not ideal to have an additional column, but I could not get it to work in one calc columns. This works for now.
IsCurrentMonthCust 3 =SUM('DimCalendar - Forecast'[IsCurrentMonthCust 2])
I figured it out. I changed the field to whole number and added a column and/or measure to sum the results. Not ideal to have an additional column, but I could not get it to work in one calc columns. This works for now.
IsCurrentMonthCust 3 =
SUM('DimCalendar - Forecast'[IsCurrentMonthCust 2])