if match condition help

[mahitham]

Hi Experts,

Can any one please help me on below requirement.

I have to create one new field  from below mentioned 4 fields (Entity, Feedback, Start date and end date ) named [T/N Product] with 2 records i.e., Trending Product and Non Trending Product records

based on existing fields condition using if match expression.

Conditions:

if  Entity  = Sales then Trending Product

if  Entity  = Manager then Non Trending Product but only if Feedback = Yes else Trending Product

If  Entity  = Products  then Non Trending Product but only if Feedback =No  and (End date -start date)<=3years

if  Entity  = Rating then Trending Product

if any new field added at Entity it has to be treated as Trending Product

Entity            Feedback          Start date            end date

Sales                Yes                  01/02/2015          05/01/2018

Manger            No                    01/02/2017          05/01/2018

Products                                    01/02/2017          05/01/2018

Rating

Please help me on this.

Thanks in advance.

[sunny_talwar]

May be try creating a master dimension and see if that works... if that doesn't work... then I am not sure you will be able to do this without some manipulation in the script