DAX formula help

Question

Hi All - I need help with the&nbsp;formulas&nbsp;to produce the results in the last column below. Essentially, I need to calculate the count of weeks for each participant where s/he attended at least 3 days for at least 60 combined mins per day where:&nbsp;Attended_c = AttendedFitness_Rollup = FitnessAttendance Week = &gt;=22&nbsp;In the sample data for Mitch below, the result should be 1 (week 28).&nbsp;NameDateAttended__cTime_Spent_ActivityNameAttendance&nbsp;WeekFitness_RollupCount&nbsp;of&nbsp;Weeks&nbsp;with&nbsp;3&nbsp;or&nbsp;more&nbsp;distinct&nbsp;days&nbsp;of&nbsp;60+mins&nbsp;MitchWednesday,&nbsp;November&nbsp;28,&nbsp;2018Attended607th&nbsp;Grade&nbsp;Nutrition&nbsp;#322&nbsp;1MitchMonday,&nbsp;December&nbsp;03,&nbsp;2018Attended607th&nbsp;Grade&nbsp;Nutrition&nbsp;#423&nbsp;1MitchWednesday,&nbsp;January&nbsp;09,&nbsp;2019Attended607th&nbsp;Grade&nbsp;Nutrition&nbsp;#128&nbsp;1MitchThursday,&nbsp;November&nbsp;29,&nbsp;2018Attended240General&nbsp;Attendance22&nbsp;1MitchMonday,&nbsp;December&nbsp;03,&nbsp;2018Attended240General&nbsp;Attendance23&nbsp;1MitchTuesday,&nbsp;December&nbsp;04,&nbsp;2018Attended240General&nbsp;Attendance23&nbsp;1MitchWednesday,&nbsp;December&nbsp;05,&nbsp;2018Attended240General&nbsp;Attendance23&nbsp;1MitchThursday,&nbsp;November&nbsp;01,&nbsp;2018&nbsp;240General&nbsp;Attendance18&nbsp;1MitchFriday,&nbsp;November&nbsp;02,&nbsp;2018&nbsp;60Zumba18Fitness1MitchMonday,&nbsp;November&nbsp;05,&nbsp;2018&nbsp;60Zumba19Fitness1MitchFriday,&nbsp;November&nbsp;30,&nbsp;2018Attended180General&nbsp;Attendance22&nbsp;1MitchTuesday,&nbsp;November&nbsp;27,&nbsp;2018Attended60Math&nbsp;Enrichment22&nbsp;1MitchTuesday,&nbsp;December&nbsp;04,&nbsp;2018Attended60Math&nbsp;Enrichment23&nbsp;1MitchTuesday,&nbsp;November&nbsp;20,&nbsp;2018Attended60Fitness21Fitness1MitchMonday,&nbsp;November&nbsp;26,&nbsp;2018Attended60Fitness22Fitness1MitchTuesday,&nbsp;November&nbsp;27,&nbsp;2018Attended60Fitness22Fitness1MitchMonday,&nbsp;December&nbsp;03,&nbsp;2018Attended60Fitness23Fitness1MitchWednesday,&nbsp;December&nbsp;05,&nbsp;2018Attended60Fitness23Fitness1MitchThursday,&nbsp;January&nbsp;10,&nbsp;2019Attended30Basketball28Fitness1MitchTuesday,&nbsp;January&nbsp;08,&nbsp;2019Attended60Fitness28Fitness1MitchWednesday,&nbsp;January&nbsp;09,&nbsp;2019Attended60Fitness28Fitness1MitchThursday,&nbsp;January&nbsp;10,&nbsp;2019Attended30Fitness28Fitness1MitchMonday,&nbsp;January&nbsp;14,&nbsp;2019Attended60Fitness29Fitness1MitchMonday,&nbsp;November&nbsp;19,&nbsp;2018Attended60Basketball21Fitness1

ashish_mathur · Answer

Hi,
&nbsp;
Should that be a calculated column formula or a measure?&nbsp; If it has to be a measure, then share the link from where i can download your PBI file.

anonymous · Answer

Ashish_Mathur&nbsp;I need it to be a calulated column, thanks.

ashish_mathur · Answer

Hi,
&nbsp;
I tried but could not get the correct answer using a calculated column formula.

anonymous · Answer

Can anyone help with this?

Forum Discussion

DAX formula help

4 Replies

Related content

DAX Formula Help

DAX Formula

DAX Formula

DAX Formula

Dax Formula correction help

Name	Date	Attended__c	Time_Spent_	ActivityName	Attendance Week	Fitness_Rollup	Count of Weeks with 3 or more distinct days of 60+mins
Mitch	Wednesday, November 28, 2018	Attended	60	7th Grade Nutrition #3	22		1
Mitch	Monday, December 03, 2018	Attended	60	7th Grade Nutrition #4	23		1
Mitch	Wednesday, January 09, 2019	Attended	60	7th Grade Nutrition #1	28		1
Mitch	Thursday, November 29, 2018	Attended	240	General Attendance	22		1
Mitch	Monday, December 03, 2018	Attended	240	General Attendance	23		1
Mitch	Tuesday, December 04, 2018	Attended	240	General Attendance	23		1
Mitch	Wednesday, December 05, 2018	Attended	240	General Attendance	23		1
Mitch	Thursday, November 01, 2018		240	General Attendance	18		1
Mitch	Friday, November 02, 2018		60	Zumba	18	Fitness	1
Mitch	Monday, November 05, 2018		60	Zumba	19	Fitness	1
Mitch	Friday, November 30, 2018	Attended	180	General Attendance	22		1
Mitch	Tuesday, November 27, 2018	Attended	60	Math Enrichment	22		1
Mitch	Tuesday, December 04, 2018	Attended	60	Math Enrichment	23		1
Mitch	Tuesday, November 20, 2018	Attended	60	Fitness	21	Fitness	1
Mitch	Monday, November 26, 2018	Attended	60	Fitness	22	Fitness	1
Mitch	Tuesday, November 27, 2018	Attended	60	Fitness	22	Fitness	1
Mitch	Monday, December 03, 2018	Attended	60	Fitness	23	Fitness	1
Mitch	Wednesday, December 05, 2018	Attended	60	Fitness	23	Fitness	1
Mitch	Thursday, January 10, 2019	Attended	30	Basketball	28	Fitness	1
Mitch	Tuesday, January 08, 2019	Attended	60	Fitness	28	Fitness	1
Mitch	Wednesday, January 09, 2019	Attended	60	Fitness	28	Fitness	1
Mitch	Thursday, January 10, 2019	Attended	30	Fitness	28	Fitness	1
Mitch	Monday, January 14, 2019	Attended	60	Fitness	29	Fitness	1
Mitch	Monday, November 19, 2018	Attended	60	Basketball	21	Fitness	1