cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
msarfaraz Frequent Visitor
Frequent Visitor

dax

 dax.JPG

 

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
Super User

Re: dax

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


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

Proud to be a Datanaut!




View solution in original post

v-huizhn-msft Super Contributor
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

View solution in original post

3 REPLIES 3
Super User
Super User

Re: dax

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


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

Proud to be a Datanaut!




View solution in original post

v-huizhn-msft Super Contributor
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

View solution in original post

v-huizhn-msft Super Contributor
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

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

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

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

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.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

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

Users Online
Currently online: 111 members 2,618 guests
Please welcome our newest community members: