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
aridavid
Frequent Visitor

Counting items from two date columns in one single timeline

Hello,

 

I'm trying to plot a table where I can observe on a timeline (months), how many items are between two given dates (start & end) from a table. The problem I'm having is that these two dates are rperesented in two different columns and I can't find a good way of relating them to a Calendar table in order to get what I want. Example:

 

TableX

 UserProject StartDate EndDate 
 A Project1  10/5/2021  12/7/2021
 Project2 4/21/2021  7/28/2021
 Project3 5/23/2021  9/13/2021
 Project4 7/18/2021  11/6/2021
 Project5 11/7/2021  11/18/2021
 Project6 8/16/2021  12/28/2021
 Project711/13/2021  12/4/2021

 

From TableX I'd like to tell on a given month, how many projects would the person have assigned, and observe it by month. Liek this:

 

Result

UserTotal ProjectsJanFebMarAprMayJunJulAugSeptOctNovDec
A2000111100111
B3000011222120
C2000000011122

 

Would this be even possible?

 

Thanks a lot.

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

@aridavid 
Take a look at these two Quick Measures as I think you want something like them.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364
https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

2 REPLIES 2
Greg_Deckler
Super User
Super User

@aridavid 
Take a look at these two Quick Measures as I think you want something like them.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364
https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Works like a charm, that's so clever! I was busting my brain trying relationships... Thanks @Greg_Deckler !

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors