Trending Revenue for clients active in a specific quarter

kjohnanand — Fri, 14 Jun 2024 02:36:20 GMT

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

Solved: Re: Trying to get trending revenue for clients act... - Microsoft Fabric Community

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.

https://docs.google.com/file/d/1uC3vqOFRTelL8YjJlkoW8RDmQO7B9jZr/edit?usp=docslist_api&filetype=msexcel

https://drive.google.com/file/d/19oDabT3zqaIOvxAASBkoRE0kSEjb5ki6/view?usp=drivesdk

https://docs.google.com/file/d/1htFfxaemUUdQIoCWXI1MKZZV9GPSSjFE/edit?usp=docslist_api&filetype=msexcel

Re: Trending Revenue for clients active in a specific quarter

lbendlin — Sat, 15 Jun 2024 22:53:47 GMT

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-Forum/ba-p/963216

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/1447523

topic Re: Trending Revenue for clients active in a specific quarter in DAX Commands and Tips

Trending Revenue for clients active in a specific quarter

Re: Trending Revenue for clients active in a specific quarter