Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
SabinBI
Regular Visitor

Quarter to date variance

Hi guys,

I have a fact table with account balances and a dim date that contains date and previous quarter end for each date.
Both tables contain info about working days only.
I would like to prepare a report that returns the % variance QtD of the accounts balance sum based on the date selected in a slicer.
For example the sum of the balances is 12 usd on 5 Apr 2019, the sum of the balances is 10 usd on 29 Mar 2019 (end of previous Q) and the report should return 20%.
If I change the slicer value to 4 Apr then the report should compare the sum from 4 Apr to the sum of 29 Mar. Consequently if I choose 12 Jul 2019 it should compare with 30 Jun.
How can I achieve this please?

Many thanks,
Sabin
0 REPLIES 0

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.