cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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!




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

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!




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

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
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 98 members 1,493 guests
Please welcome our newest community members: