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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
kjohnanand
Helper I
Helper I

Trending Revenue for clients active in a specific quarter

Hello everyone, this is a follow-up to my previous question on here (linked below).

 

The solution outlined here worked well, but now I am attempting to transition into a new dataset with a slightly different format. When I tried to translate the same cohort formula over from there, I ran into an issue where my graphs aren't changing with the filter. I would like some assistance finding the issue here.  

 

 
This is the formula I'm using to calculate rolling 12 revenue with the new data source. "Entity by Product Revenue" is the new data file I'm switching over to. "RCB Core Revenue" is the old file which I'm using to distinguish between active and inactive clients (might not be necessary).
 

 

 

 

Rev R12 by Product =
CALCULATE(SUM('Entity by Product Revenue'[R12 Revenue]), '_QuarterEndTable'[Year.Quarter] = MAX('_QuarterEndTable'[Year.Quarter]), 'RCB Core Revenue'[Active vs Deconverted] = "Active")

 

 

 

This is the new cohort formula I'm using. It's very similar to the one in the previous solution, with smaller alterations. 

 

 

Rev Cohorts Products = CALCULATE([Rev R12 by Product],CALCULATETABLE(SUMMARIZE('Entity by Product Revenue', 'Entity by Product Revenue'[Ent Number]), ALL(_QuarterEndTable), USERELATIONSHIP('Entity by Product Revenue'[Quarter], _QuarterEndTable2[Quarter and Year])))

 

 

 

I've linked the files below that are relevant to this. Top is the new file I'm transitioning to, middle is test file from previous solution, and bottom file is the old file I'm transitioning from.

 
1 REPLY 1
lbendlin
Super User
Super User

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question. Your sample file is way too big.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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

Top Solution Authors
Top Kudoed Authors