Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi guys and gals,
I have a question about a calculated column and if its possible in Power Bi and how it's possible.
This is the table.
Name -diner A -diner- B time - seats
The name is the name of the person that is reserving a seat or multiple seats.
Diner A is standard and if its booked it will say true if not false
Diner B is deluxe. same apply-es here
Time is which time they want to come
Seats how many people are coming.
Diner A costs 50 euro
Diner B costs 100 euro
How can make an additional column in power Bi that will look at collum diner A and diner B and will calculate the cost?
Name -diner A -diner- B time - seats - costs
ABC. True. false 18:00 2 50 euro
And that it will apply the rule with future reservations.
Power Bi is hooked on the database of the website.
Thanks in advance.
If its the wrong part of the forum I'm sorry.
Solved! Go to Solution.
Seems like a calculated column with a forumla like:
Column = IF([Diner A] = TRUE(),"50 euros","100 euros")
This assumes if Diner A is false that Diner B is true but you can adjust from here, such as:
Column = IF([Diner A] = TRUE(),"50 euros",IF([Diner B] = TRUE(),"100 euros","error"))
Seems like a calculated column with a forumla like:
Column = IF([Diner A] = TRUE(),"50 euros","100 euros")
This assumes if Diner A is false that Diner B is true but you can adjust from here, such as:
Column = IF([Diner A] = TRUE(),"50 euros",IF([Diner B] = TRUE(),"100 euros","error"))
User | Count |
---|---|
121 | |
72 | |
71 | |
57 | |
50 |
User | Count |
---|---|
167 | |
83 | |
68 | |
66 | |
55 |