yuhkaoMicrosoft Employee6 years agoSolvedRolling 3 month Hi I would like to have rolling data for calculation of [measure] for 3 months. please help me to create it. thanks date format is in YYYYMM format, which is text in data type now. for ...Show MoreMFelix to yuhkao6 years agoHi yuhkao , This code is a calculated column in DAX in order to have a date column to use on the rolling 3 months. Month_End_DAX = EOMONTH(DATE(LEFT('Table'[Date];4);RIGHT('Table'[Date];2);1);0)
MFelix to yuhkao6 years agoHi yuhkao , This code is a calculated column in DAX in order to have a date column to use on the rolling 3 months. Month_End_DAX = EOMONTH(DATE(LEFT('Table'[Date];4);RIGHT('Table'[Date];2);1);0)
MFelix to yuhkao6 years agoHi yuhkao , This code is a calculated column in DAX in order to have a date column to use on the rolling 3 months. Month_End_DAX = EOMONTH(DATE(LEFT('Table'[Date];4);RIGHT('Table'[Date];2);1);0)
yuhkaoMicrosoft Employee6 years agoMFelix DAX:Month_End_DAX = EOMONTH(DATE(LEFT('Table'[Date];4);RIGHT('Table'[Date];2);1);0) is it
MFelixSuper User to yuhkao6 years agoHi yuhkao , Don't understand what you mean. What is your question?
yuhkaoMicrosoft Employee to MFelix6 years agohi MFelix sorry i think system was error. my question is DAX for create table? column? measure?thanks
yuhkaoMicrosoft Employee to MFelix6 years agohi MFelix sorry i think system was error. my question is DAX for create table? column? measure?thanks
Related contentRolling values for 3 monthsRolling average last 3 monthsRolling 3 months not working properlyRolling 3 month average - 3 monthsRolling 3 months
