Forum Discussion
kkoc3karan
3 years agoFrequent Visitor
Need Help with this DAX calculation
Data CRM ID CRM Close Date Task ID Task Close Date 1 12/07/2023 1.1 14/07/2023 1 12/07/2023 1.2 15/07/2023 1 12/07/2023 1.3 16/07/2023 2 2.1 17/07/2023 2 ...
- 3 years ago
I have figured out however i am unsure if this is the most optimal way
happy for someone to suggest better way
countx( filter( summarize( test, test[CRM ID], test[CRM Close Date], "_1", countrows( filter( test, not isblank(test[Task Close Date]) ) ), "_2", countrows(test) ), isblank(test[CRM Close Date]) && [_1]=[_2] ), test[CRM ID] )
kkoc3karan
3 years agoFrequent Visitor
I have figured out however i am unsure if this is the most optimal way
happy for someone to suggest better way
countx(
filter(
summarize(
test,
test[CRM ID],
test[CRM Close Date],
"_1",
countrows(
filter(
test,
not isblank(test[Task Close Date])
)
),
"_2",
countrows(test)
),
isblank(test[CRM Close Date]) && [_1]=[_2]
),
test[CRM ID]
)