topic Re: Create calendar column value based on a criteria in DAX Commands and Tips

Create calendar column value based on a criteria

EnderWiggin — Thu, 15 Jul 2021 08:37:40 GMT

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!

Re: Create calendar column value based on a criteria

Anonymous — Thu, 15 Jul 2021 10:18:16 GMT

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

Re: Create calendar column value based on a criteria

EnderWiggin — Thu, 15 Jul 2021 10:20:14 GMT

This is what I want, thank you Anonymous!