Hello friends, Hope all is well!
Please help me make a DAX formula that captures the same function of the below countifs formula:
=IF(COUNTIFS($D$2:$D$13,D2,$C$2:$C$13,"",$A$2:$A$13,A2)>0,1,0)
Col D: Type
Col C: Value
Col A: Year
the attachment here should clarify; in the end if blank appears in any cell, then cell related to the "Type" and "year" will become 1.
Thank you so much in advance!
How about just telling us what you are trying to achieve?
HTH
Regards, Jeff
good question. I am trying to make a powerpivot. that will hide rows if all values dont have blanks.
I want the pivot to show the rows that have 1 or more blanks.
Please help me change the formula to a DAX formula:
=IF(COUNTIFS($D$2:$D$13,D2,$C$2:$C$13,"",$A$2:$A$13,A2)>0,1,0)
No, what I mean, what are you trying to accomplish in column E and why does it need to be a DAX formula. Won't a formula that works suffice?
In column E I see all "zeros" for A in column D and "ones" for B in column D. Can you clarify?
the formula works, but I am trying to automate the process as much as possible. people around me may forget, and the report will be a mess.
Regarding the question: Yes zeros = no issues, no blanks found. ones= cells of B found at least 1 blank, so all Bs in year 2019 will have = 1s.
Sorry, I'm not following here so I've put a call into the experts to see if they can help.
Presumably you want this as a calculated column, so that you can use as a filter.
So, use:
This will return TRUE if blank SAR values are found for the Year / Type combination, and FALSE if no blank SAR values found.
Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks