Create calendar column value based on a criteria

[EnderWiggin]

Hi All,

I would like to ask your help to create a calendar column (BeforeActualYearMonth) based on the following criteria:

If the  Calendar[YearMonth] < LoadedAt[YearMonth] then Calendar[BeforeActualYearMonth] = "BeforeActual" else Calendar[BeforeActualYearMonth] = Calendar[YearMonth]  in each row in Calendar table.

Please, see the attached file for more details:

Power BI Running Total 

PS: It is neccessary to calculate start balance of all material quanity in running total calculation.

Thank you very much in advance!

[Anonymous · Accepted solution]

BeforeActualYearMonth =
var CalendarYearMonth = Calendar[YearMonth]
// There must be just one value in LoadedAt
var LoadedAtYearMonth = SELECTEDVALUE( LoadedAt[YearMonth] )
return
	if ( CalendarYearMonth < LoadedAtYearMonth,
		"BeforeActual",
		// CalendarYearMonth must be turned into
		// a string since you can't mix types
		// in a column. If it's already text,
		// you can just use the raw value without >& ""<.
		CalendarYearMonth & ""
	)

[EnderWiggin]

This is what I want, thank you @Anonymous!