Forum Discussion
Column with previous date
Hello! i am currently using this DAX as a calculated column to return the previous periods usertotal: Prev_Date = VAR CompanyID = table[companyId] VAR Date1 = table[Date] VAR Pre_Date = CAL...
Why can't you just return the Pre_Date variable? It seems you've already calculated it. Just chang the last line to Pre_Date and get rid of the IF() statement.
I literally did that and it didnt work, I just retried and it worked thank you
edhans
Community Champion
Community ChampionExcellent! Probably some comma or space messing it up the first time you tried.