Forum Discussion
Solved
Count Services inside a Promo Combo Sales
How can I count diferent sales inside Combo Order? There is a table with all services (table_services) and another with combos (table_combos). In the "transactions_table" use all the codes, but th...
Hi brunofranc ,
Please refer to my .pbix file.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
For example, in order id 123, there are 1 combo 1005 and 1 of 504.
Combo 1005 is:
2 x IDService 502 and 3 x Service ID504
And then 2 x 45 = 90 min
3 x 60 = 180 min
And the amount is 2 +3 = 5
Hi brunofranc ,
Please refer to my .pbix file.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.