Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I need help in designing below dax. This i'm tryig to do, can anyone help on this
HoursA =
IF(OR( Active[Month]=11, Active[Month]=12),
IF( Active[Active Status]=1,
IF('Active'[Center]="Mum",480*'Active'[Prod],450*'Active'[Prod]),
IF(OR( Active[Month] other than 11 and 12 month) then
IF( Active[Active Status]=1, IF('Active'[Center]="Mum",465*'Active'[Prod],435*'Active'[Prod]),0)
)))
Solved! Go to Solution.
hard to tell what conditions you really wanted, I derived this one.
HoursA =
IF (
OR ( Active[Month] = 11, Active[Month] = 12 ),
IF (
Active[Active Status] = 1,
IF ( 'Active'[Center] = "Mum", 480 * 'Active'[Prod], 450 * 'Active'[Prod] ),
0
),
-- Active[Month] other than 11 and 12 month
IF (
Active[Active Status] = 1,
IF ( 'Active'[Center] = "Mum", 465 * 'Active'[Prod], 435 * 'Active'[Prod] ),
0
)
)
hard to tell what conditions you really wanted, I derived this one.
HoursA =
IF (
OR ( Active[Month] = 11, Active[Month] = 12 ),
IF (
Active[Active Status] = 1,
IF ( 'Active'[Center] = "Mum", 480 * 'Active'[Prod], 450 * 'Active'[Prod] ),
0
),
-- Active[Month] other than 11 and 12 month
IF (
Active[Active Status] = 1,
IF ( 'Active'[Center] = "Mum", 465 * 'Active'[Prod], 435 * 'Active'[Prod] ),
0
)
)
Hi superuser, Thanks for your prompt reply. what I'm trying to do is, if month = 11 or 12 (11 is Nov and 12 is Dec), then below line should work-
Active[Active Status] = 1, IF ( 'Active'[Center] = "Mum", 480 * 'Active'[Prod], 450 * 'Active'[Prod] ),
else, if month is other than 11 or 12 (i.e. 1 or 2 or 3 / 4 / 5 /6/7/8/9/10) means from Jan till Oct then below code work..
Active[Active Status] = 1, IF ( 'Active'[Center] = "Mum", 465 * 'Active'[Prod], 435 * 'Active'[Prod] ),
I'm getting values for months 11 or 12 correctly but for other moths I'm getting 0.
Hey Hi mwegener (super user), you're correct. your solution is correct, just got that what you've given me.. Great. Thank You so much..
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |