Forum Discussion

EnderWiggin's avatar
EnderWiggin
Icon for Helper I rankHelper I
5 years ago
Solved

Create calendar column value based on a criteria

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!

Need Help DAX measure
  • Anonymous's avatar
    Anonymous
    5 years ago

     

    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 & ""
	)

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

     

    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 & ""
	)