cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Super User
Super User

Re: Combining Data from multiple tables on a shared timeline

Hi @asaft,

 

I believe is that what is happening is that you are getting the total values of the Closed cases, but not sure can you possible share some sample data?

 

Regards,

Mfelix



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




asaft Regular Visitor
Regular Visitor

Re: Combining Data from multiple tables on a shared timeline

Hi @MFelix,

 

What if instead of this calculation, I will pull into the date table, another column with the number of cases opened on each date. It would serve the same purpose. Just that not sure this is logically possible. The Open date and the close date are on the same table. 

 

What would be the best way to privately share with you a sample data?

 

Thanks for your persistence (-:

 

Asaf

Super User
Super User

Re: Combining Data from multiple tables on a shared timeline

Hi @asaft,

 

Just created a model with two table with your data Backlog and Closed cases mades changes to distinct count on your measure and got the result below.

 

Count accumulate = 
VAR previous =
MIN ('Date Table'[Date]) - 1
VAR Ranking =
RANKX (
ALLSELECTED ('Date Table'[Date]);
CALCULATE (DISTINCTCOUNT(Backlog[Case Number]));
;
ASC
) //Calculates the ranking based on the period number in order to work with different period slicers
RETURN
DISTINCTCOUNT(Backlog[Case Number])
- CALCULATE (
DISTINCTCOUNT(Backlog[Case Number]);
FILTER (ALL(Backlog);Backlog[Snapshot Created Date] = Previous )
) //Calculation of variation to previous period
+ CALCULATE (
DISTINCTCOUNT('Closed Cases'[Case Number]);
FILTER(ALL('Closed Cases'); 'Closed Cases'[Date/Time Closed] = MIN('Date Table'[Date]))
)

Backlog.png

 

Believe everything is as needed. Please check it and tell me.

 

Regards,

MFelix



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




View solution in original post

Highlighted
asaft Regular Visitor
Regular Visitor

Re: Combining Data from multiple tables on a shared timeline

Thanks so much @MFelix!

 

This has been really helpful!

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 245 members 2,389 guests
Please welcome our newest community members: