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

Countrows and organize by date

I have a date table that is connected to my fact table, I need to count the number of rows per date and build a virtual table for created by, resolved by as well as average Created by based on YTD and Resolved by based on YTD.

 

At this point none of my relationships are active: so that needs to be taking into consideration. 

 

Your help is greatly appreciated.

3 REPLIES 3
Earlie Frequent Visitor
Frequent Visitor

Re: Countrows and organize by date

This is my relationship mapDates Connection.jpg

Community Support Team
Community Support Team

Re: Countrows and organize by date

Hi @Earlie ,

For the scenario, I can't create a sample to test. If you can upload a dummy file, we will help you as soon as possible. If you can't, can you please share some sample data? 

 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Earlie Frequent Visitor
Frequent Visitor

Re: Countrows and organize by date

I need the IsActive by day, month,...

Based on IsActive = 1 & Hire/Term dates

 

Sample.jpg

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)