topic Re: Need Help with DAX in DAX Commands and Tips

Need Help with DAX

Anonymous — Tue, 09 May 2023 19:20:08 GMT

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

Re: Need Help with DAX

eliasayyy — Wed, 10 May 2023 07:17:07 GMT

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]),

Re: Need Help with DAX

Anonymous — Wed, 10 May 2023 15:55:09 GMT

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.

Re: Need Help with DAX

Ajendra — Wed, 10 May 2023 16:08:18 GMT

Hello,

Share some demo data along with the desire output.

Thanks!!