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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
kasiaw29
Resolver II
Resolver II

Understanding Qtr over Qtr Change Time intelligence

Hi community, 

 

I'm not looking for a solution just understanding here. I was asked to provide qtr on qtr change in my report. 

My source data does not have any data pre 2021, so things measured are for this year only, and going forward of course as time goes by. 

 

I used new quick measure to get this using PowerBI feature: 

 

IF(
	ISFILTERED('DateDim'[Date]),
	ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."),
	VAR __PREV_QUARTER =
		CALCULATE(
			[Weighted Survey Score],
			DATEADD('DateDim'[Date].[Date], -1, QUARTER)
		)
	RETURN
		DIVIDE([Weighted Survey Score] - __PREV_QUARTER, __PREV_QUARTER)
)

 

My visual then for QTR1 of this year gives me very high percentage, why is that? 

kasiaw29_0-1626877417080.png

 

I'd of thought that Q1 would not be as high as there is no previous qtr? There is no data for Q4 of 2020. 

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@kasiaw29 , that is strange. 

But can check after removing .date and making sure date table is marked as a date table 

like 

DATEADD('DateDim'[Date], -1, QUARTER)

 

Can you share both current qtr and last qtr values in a  table visual , along with change % 

 

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@kasiaw29 , that is strange. 

But can check after removing .date and making sure date table is marked as a date table 

like 

DATEADD('DateDim'[Date], -1, QUARTER)

 

Can you share both current qtr and last qtr values in a  table visual , along with change % 

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.