cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cstephan007 Frequent Visitor
Frequent Visitor

PERIODS DIFFERENCES (TTM) - CY vs PY

Hi,

 

I'm trying to create a table to compare TTM Amounts. Let's assume that I'm comparing FY16 (12/31/2017), FY17 (12/31/2017), FY18 (12/31/2018) and TTM Apr-19 (04/30/2019), so, I created the following script. 

 

TTM CY vs PY =
VAR TTM = [Total TTM]
VAR TTM_PY =
    CALCULATE ( [Total TTM], DATEADD ( Date_Table[Period End Date], -365DAY ) )
RETURN
    TTM - TTM_PY

 

I'm having two issues with this script. 
1) This script is comparing FY16 to the previous period that does not exist in any table that I have. Is there somehow a way to just compare FY16 to FY17?

2) When I'm comparing TTM Apr-19, this script is comparing TTM Apr-19 with TTM Apr-18, however I would like to compare any TTM period in the table with the last FY available (in this case, FY18). 

 

I really appreciate any help and I can provide more info if necessary. 

PS: My TTM and TTM PY is working well, my problem, is when I compare it.

 

Thank you 

 

1 REPLY 1
cstephan007 Frequent Visitor
Frequent Visitor

Re: PERIODS DIFFERENCES (TTM) - CY vs PY

Just a quick update. For the item #1, I found a solution. Just need for the item #2.

Helpful resources

Announcements
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 420 members 4,191 guests
Please welcome our newest community members: