The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello i am new to DAX and trying to calculate a total cost to a ticket. My table looks like this
TicketID Company Hours Hourly Cost
1 comapny a 1 100
1 comapny a 0.5 125
2 Company b 5 50
3 Company c 2 150
3 Company c 1 125
3 Company c 3 75
Each ticket can have multiple entries with different costs. I am looking for the total cost of each Ticket.
I have tried using
cost = [hours] * [hourly cost] but it errors and says a single value for the column cannot be determined. I have been messing with sum and sumx but cannot figure out the right formula to come up with one cost value for the ticket as a whole. Any help in the right direction is appreciated. Thanks!
Solved! Go to Solution.
Hello, can you have a look at this?
https://drive.google.com/drive/folders/1CO5accqcXUeUUvlqeRNTG-xFKAmsOSLJ?usp=sharing
Best,
Milan
PS, mark my answer as solution if it fits your needs.
Hello, can you have a look at this?
https://drive.google.com/drive/folders/1CO5accqcXUeUUvlqeRNTG-xFKAmsOSLJ?usp=sharing
Best,
Milan
PS, mark my answer as solution if it fits your needs.