Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Need Help with DAX

Hello, Hope you all are doing great.

 

I am stuck in one conditional DAX formula 
I have one table in which I have 5 Columns trdr1, trdr2, week, trdr1 prft and trdr2 prft.

 

Now I want to calculate profit based on some condition like if trdr1 = 51 and week = 1 than calculate sum of trdr1 prft
and if trdr2 = 51 and week =2 (Suppose week =2 is not present where trdr1 =51 ) than calculate sum of trdr2.

If we have matching values like trdr1 = 51 and week = 1, trdr2 = 51 and week = 1 than it should consider value from trdr1 prft

 

I hope I have explained problem statement fully.

 

Please help me with this problem it will be very helpful to me

 

Thanks in advance

 

3 Replies

  • eliasayyy's avatar
    eliasayyy
    Memorable Member
    3 years ago

    not sure if i got you correctly but you could try using if or switch 

    Condition = 
    SWITCH(
         TRUE(),
         AND('table'[trdr1] = 51 , 'table'[week] = 1) , sum('table'[trdr1]),
         AND('table'[trdr2] = 51 , 'table'[week] = 2) , sum('table'[trdr2]),
         AND('table'[trdr1] = 51 , AND('table'[week] = 1, table'[trdr2] = 51)) , sum('table'[trdr1]),

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thanks for your reply,
    This solution is static one, I want dynamic measure, Like instead of using trdr1=51 and week =1, I want to sum for all trdrs and weeks.

  • Ajendra's avatar
    Ajendra
    Resolver I
    3 years ago

    Hello,

     

    Share some demo data along with the desire output.

     

    Thanks!!