cancel
Showing results for
Did you mean:
Frequent Visitor

## dax

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

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User

## Re: dax

Hi @msarfaraz,

First of all please elaborate your questions better otherwise pleople will not be abble to help you.

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

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Super Contributor

## Re: dax

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

3 REPLIES 3
Super User

## Re: dax

Hi @msarfaraz,

First of all please elaborate your questions better otherwise pleople will not be abble to help you.

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

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Super Contributor

## Re: dax

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

Super Contributor

## Re: dax

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

Announcements

#### Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

#### Community News & Announcements

Get your latest community news and announcements.

#### Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 111 members 2,618 guests
Recent signins: