Forum Discussion
Solved
Conditionally Count Calculated Values in a Column
Greetings... here is my problem of the week. Spent 5 days and a lot of code and have came up empty. Hope there is some help for me out there. Having fun trying to figure it out but running into a...
Try to add a new column with the code below?
Value =
IF([September]>=10,1)+
IF([October]>=10,1)+
IF([Novembee]>=10,1)
I see where you are going. I may not have detailed my setup enough, the month names are not data/calculated columns. The month columns equal the heirachy 'Month' from the 'Start Date' column in the table.
Tried this approach but no cigar... still in the deep end of the pool.
Column = IF(
'Table'[Startdate].[Month]= "September" && AVERAGE('Table'[Closeddate] (Difference)]) >=10 ,1 +
IF(
'Table'[Startdate].[Month]= "October" && AVERAGE('Table'[Closeddate] (Difference)]) >=10 ,1 +
IF(
'Table'[Startdate].[Month]= "November" && AVERAGE('Table'[Closeddate] (Difference)]) >=10 ,1
)
))