Forum Discussion
Solved
dax
if Night column is - value , Nights x Rooms = 0, if Night column is + value than Night * rooms = Answer
- Hi msarfaraz,
First of all please elaborate your questions better otherwise pleople will not be abble to help you.
Read this https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490 to help you along.
Don't know if you want a measure or a column but the formula should be something like this
Night rooms =
IF (
SUM ( Table[Nights] ) < 0,
0,
SUM ( Table[Nights] ) * SUM ( Table[Rooms] )
)
Regards,
MFelix
3 Replies
Hi msarfaraz,
Have you resolved your issue? If you have, please mark the helpful reply as answer, more people will benefit from here.
Thanks,
Angelia- Hi msarfaraz,
First of all please elaborate your questions better otherwise pleople will not be abble to help you.
Read this https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490 to help you along.
Don't know if you want a measure or a column but the formula should be something like this
Night rooms =
IF (
SUM ( Table[Nights] ) < 0,
0,
SUM ( Table[Nights] ) * SUM ( Table[Rooms] )
)
Regards,
MFelix