Forum Discussion
Calculate and dateadd issue
Hi guys New to Power BI. I'm trying to figure out why my CALCULATE and DATEADD formula isn't working. UsersLastWeek = CALCULATE(SUM('Users/New Users'[New Users]),dateadd(FIRSTNONBLANK(...
Greg_Deckler
Community Champion
Community ChampionYou need to use EARLIER most likely. See my article on it here, different problem but you can use the same technique. See my article on Mean Time Before Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/339586
OK, thanks Greg. I'll have a look.
James