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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

How many days by month for each activities

Hi Everyone,

 

I have a table of scheduled activites, each with a start date and a end date.

Now, I need to know, for each activites and every month, how many days I spent in the month.

 

I don't have a clue where to start and which formula I need.

Any ideas please ? 🙂

 
 

2020-03-12 12_04_58-Window.png

 

Regards 🙂

 

2 REPLIES 2
V-pazhen-msft
Community Support
Community Support

@Anonymous 

 

The phone you provide is not showing much useful information, the can be something like: 

Measure = CALCULATE(COUNTROWS([spendtime?]),ALLEXCEPT('Table','Table'[Activity],'Table'[Date].[Month]),FILTER('Table',[Spendtime?] ="Yes"))

 

But you would need to provide a sample data or file, so we can have a look at the case for a solution. 

Best regards
Paul Zheng

amitchandak
Super User
Super User

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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