topic Re: Calculating tariff bands in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculating-tariff-bands/m-p/3184170#M115225 <P>Yes correct! <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span>&nbsp;</P> Wed, 12 Apr 2023 13:41:00 GMT Anonymous 2023-04-12T13:41:00Z Calculating tariff bands https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculating-tariff-bands/m-p/3184129#M115220 <P>Hi I want to create a column or measure that will help me calculate how much a parking session is.</P><P>&nbsp;</P><P>Below is my tariff rate table.</P><P>&nbsp;</P><P>Example I may have a customer who parks in zone AA on a Monday between 10am till 18pm. I want to use the below tariff rate table to calculate how much this parking session will cost me.</P><TABLE><TBODY><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>Tariff Start</TD><TD>Tariff End</TD><TD>Tariff Start</TD><TD>Tariff End</TD><TD>Tariff Start</TD><TD>Tariff End</TD><TD>Tariff Start</TD><TD>Tariff End</TD><TD>Tariff Start</TD><TD>Tariff End</TD></TR><TR><TD>Zone</TD><TD>Cost of one hour staff parking</TD><TD>Cost of one Min</TD><TD>Monday</TD><TD>Monday</TD><TD>Tuesday</TD><TD>Tuesday</TD><TD>Wednesday</TD><TD>Wednesday</TD><TD>Thursday</TD><TD>Thursday</TD><TD>Friday</TD><TD>Friday</TD></TR><TR><TD>A</TD><TD>£3.00</TD><TD>£0.05000</TD><TD>08:30</TD><TD>19:30</TD><TD>08:30</TD><TD>19:30</TD><TD>08:30</TD><TD>19:30</TD><TD>08:30</TD><TD>19:30</TD><TD>08:30</TD><TD>23:00</TD></TR><TR><TD>AA</TD><TD>£1.00</TD><TD>£0.01667</TD><TD>10:00</TD><TD>11:00</TD><TD>10:00</TD><TD>11:00</TD><TD>10:00</TD><TD>11:00</TD><TD>10:00</TD><TD>11:00</TD><TD>10:00</TD><TD>11:00</TD></TR><TR><TD>AA</TD><TD>£1.00</TD><TD>£0.01667</TD><TD>15:00</TD><TD>16:00</TD><TD>15:00</TD><TD>16:00</TD><TD>15:00</TD><TD>16:00</TD><TD>15:00</TD><TD>16:00</TD><TD>15:00</TD><TD>16:00</TD></TR><TR><TD>AS</TD><TD>£1.00</TD><TD>£0.01667</TD><TD>09:00</TD><TD>11:00</TD><TD>09:00</TD><TD>11:00</TD><TD>09:00</TD><TD>11:00</TD><TD>09:00</TD><TD>11:00</TD><TD>09:00</TD><TD>11:00</TD></TR><TR><TD>AS</TD><TD>£1.00</TD><TD>£0.01667</TD><TD>14:00</TD><TD>16:00</TD><TD>14:00</TD><TD>16:00</TD><TD>14:00</TD><TD>16:00</TD><TD>14:00</TD><TD>16:00</TD><TD>14:00</TD><TD>16:00</TD></TR><TR><TD>B</TD><TD>£1.00</TD><TD>£0.01667</TD><TD>09:00</TD><TD>18:00</TD><TD>09:00</TD><TD>18:00</TD><TD>09:00</TD><TD>18:00</TD><TD>09:00</TD><TD>18:00</TD><TD>09:00</TD><TD>18:00</TD></TR><TR><TD>BB</TD><TD>£1.00</TD><TD>£0.01667</TD><TD>10:00</TD><TD>11:00</TD><TD>10:00</TD><TD>11:00</TD><TD>10:00</TD><TD>11:00</TD><TD>10:00</TD><TD>11:00</TD><TD>10:00</TD><TD>11:00</TD></TR><TR><TD>BB</TD><TD>£1.00</TD><TD>£0.01667</TD><TD>15:00</TD><TD>16:00</TD><TD>15:00</TD><TD>16:00</TD><TD>15:00</TD><TD>16:00</TD><TD>15:00</TD><TD>16:00</TD><TD>15:00</TD><TD>16:00</TD></TR></TBODY></TABLE> Wed, 12 Apr 2023 13:27:54 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculating-tariff-bands/m-p/3184129#M115220 Anonymous 2023-04-12T13:27:54Z Re: Calculating tariff bands https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculating-tariff-bands/m-p/3184138#M115222 <P>the other undefined hours are free? like 11:00 to 15:00 on Monday?</P> Wed, 12 Apr 2023 13:33:09 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculating-tariff-bands/m-p/3184138#M115222 FreemanZ 2023-04-12T13:33:09Z Re: Calculating tariff bands https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculating-tariff-bands/m-p/3184170#M115225 <P>Yes correct! <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span>&nbsp;</P> Wed, 12 Apr 2023 13:41:00 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculating-tariff-bands/m-p/3184170#M115225 Anonymous 2023-04-12T13:41:00Z