Forum Discussion
Comparing rows - Need to match column values between rows as criteria for new column
Try as a new column
if(isblank( maxx(filter(table,table[location] =earlier([location]) && table[Brand] = "PRIVATE LABEL" && earlier(table[brand])="OUR PRIVATE LABEL"),table[VOULME])), table[VOULME],0)Might have to do some changes.
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges
Connect on Linkedin
Try as a new column
if(isblank(
maxx(filter(table,table[location] =earlier([location]) && table[Brand] = "PRIVATE LABEL"
&& earlier(table[brand])="OUR PRIVATE LABEL"),table[VOULME])), table[VOULME],0)
Might have to do some changes.
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges
Connect on Linkedin
Thanks goes to you and dax for providing great solutions! I had to reverse a few things to get it working, but I'm validating everything now, and it seems to be good.
dax : I really like your solution, and would generally prefer it, however, my dataset has more columns than I displayed above, and I had a little difficulty getting it all in there (probably making a typo on my end). Thank you for introducing me to grouping - It looks like cleaning my data and getting it the way I want it to is taking on a whole new dimension now - this is great!
