Forum Discussion
MarcUrdang
Post Patron
Post PatronVariance and variance %
Please advise on how to create a variance and a variance % as per below: I have created two calculations which compute a measure for a period of time. This year to date and last year to date: 1....
Hi,
See my attached pbix file.
Hope this can help.
Best Regards,
Giotto
MarcUrdangPost Patron
Post PatronI was originally using the itelligence option (quick measures) which actually worked .. but changed the calcs manually shown in my original post ... it might be 'weird' but as a fairly new user I'm just trying to find my way.
Will try your idea and await other replies which might also help show me the way.
thanks for your help thus far
Marc
Greg_Deckler
Community Champion
Community ChampionMarcUrdang - Just remember, sample data just has to represent your actual data enough to recreate the problem.