How to Calculate Days in Different Months

[EmmaLiuLiu]

I promise I did my research on the internet before I post a new thread here. lol

I have a table like this:

Final	Xtime Start Date	End Date	Xtime End Date	Export Date	Days Count	$/day
CM	1/15/2024		1/31/2024	3/8/2024	17	20
	2/1/2024		2/20/2024	3/3/2024	20	55
0	1/20/2024		2/5/2024	3/8/2027	0	15
End 2/28	2/22/2024	2/28/2024	3/5/2024		7	26
End 3/5	2/22/2024	3/5/2024	3/8/2024	3/3/2024	13	14

When the column Final is "CM" or blank, use column Xtime Start Date and Xtime End Date to calculate Days Count. When column Final is 0, Days Count is 0. When column Final has an "End" date, use column Xtime Start Date and End Date to calculate Days Count. I need to create a meausure to calculate the Days Count for different months. I don't even know where to start since there are different date columns for different values from column Final. When I create a bar chart based on time (year.month), I will be able to see Days Count by month. Help PLEASE!

[lbendlin · Accepted solution]

[EmmaLiuLiu]

Thank you so much @ibendlin. It worked!