Forum Discussion
Solved
Create a custom column by adding two conditions
Hello everyone! below is a table I have: I am trying to add custom columns that shows values as shown below in yellow: I am trying power query as shown below: custom column...
AVGUser_PBI Try this to see if it works
each(
(
eachif([effective_date] < #datetime(2023,1,1,0,0,0) and [attribute] = "recorded") then [Value] else 0)+
(
eachif([capture_date] = #datetime(2023,1,1,0,0,0) and [attribute] = "estimated") then [Value] else 0))
AVGUser_PBI Try this to see if it works
each(
(each if([effective_date] < #datetime(2023,1,1,0,0,0) and [attribute] = "recorded") then [Value] else 0)
+
(each if([capture_date] = #datetime(2023,1,1,0,0,0) and [attribute] = "estimated") then [Value] else 0)
)
Yes it worked!
do you know what was I doing by keeping 'each if' in the query?