dax

[msarfaraz]

 

if Night column is - value , Nights x Rooms = 0, if Night column is + value than Night * rooms = Answer

[MFelix · Accepted solution]

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

[v-huizhn-msft]

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

[v-huizhn-msft · Accepted solution]

Hi @msarfaraz,

Please share your sample table and list expected result as @MFelix suggested. And you can create dummy sample table if your data is confidential.

Best Regards,
Angelia

[MFelix · Accepted solution]

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