Please kindly help anyone:
This is my Excel query:
=IF(AND(SUMIF($M$7:$M$15,$M17,$O$7:$O$15)>0,SUMIFS($O$7:$O$15,$M$7:$M$15,$M17,$L$7:$L$15,$L17)=0)=TRUE,"New Product","")
where its functionality is comparing the first range of values
First condition: SUMIF in AND condition: M7 to M15 (Product values) with the M17(resultant particular cell value) and if matches then add all matching same product values and check if its >0,
Second condition: SUMIFS - functionality is comparing the first criteria range of values of product with M7 to M15 (Product values) with the M17 and second ranges of values L7 to L15 (Contract values) with L17 if it matches then add all the matching same contract values and check its equal to 0
If both the above conditions are true then its New Product or else " ".
I need the same in the POWER BI, please suggest anyone so it would be very helpful.
Table 1 :
where column names are Contract, Product, Client, Value End, Value Begin
Table 2 :
Product name, Client name
Table 1 Product, Client comparing with the Table 2 Product and Client name
Only Master data table called Sheet containing Contract, Product, Client, Value End, Value Begin
PLEASE KINDLY HELP.
