web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : NlaBdjh8gqFE2zz2I3wPUU
Power Apps - Power Query
Unanswered

Determining the variance in 1 column for multiple rows.

Like (0) ShareShare
ReportReport
Posted on 29 Apr 2024 20:10:02 by

Hello all, I was not able to find my specific scenario but I am newer to Power BI and attempting to recreate some old pivot table reports within Power BI.

I am looking to add a Current YTD (CYTD) and Prior YTD (PYTD) row to calculate the variance between years.

For example, I'd like to know for January, what was my PYTD Variance (2023-2022) and then my CYTD Variance (2024-2023) and so on for each month and the total year.

 

javery529_0-1714421198290.png

 

Any guidance would be appreciated!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410 Super User 2025 Season 2

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 2

Featured topics