https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/MDURATION-function/m-p/3547087#M136407 <P>Hi I am trying to get certain values on table visual using mduration function but the values that are coming are either too large or too small which are not measurable values. Is mduration function compatible with power bi? I have used functions similar to mduration but the values are not matching with the values given in excel. How can I fix this task in power bi</P> Wed, 22 Nov 2023 15:47:57 GMT Curiouslearner 2023-11-22T15:47:57Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/MDURATION-function/m-p/3547087#M136407 <P>Hi I am trying to get certain values on table visual using mduration function but the values that are coming are either too large or too small which are not measurable values. Is mduration function compatible with power bi? I have used functions similar to mduration but the values are not matching with the values given in excel. How can I fix this task in power bi</P> Wed, 22 Nov 2023 15:47:57 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/MDURATION-function/m-p/3547087#M136407 Curiouslearner 2023-11-22T15:47:57Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/MDURATION-function/m-p/3547528#M136430 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="618200" data-lia-user-login="Curiouslearner" class="lia-mention lia-mention-user">Curiouslearner</a>&nbsp;</P> <P>The MDURATION DAX function has the same specification as the Excel function, so for the same inputs you should see the same results.</P> <P>&nbsp;</P> <P>Could you share an example PBIX file where you are seeing unexpected results? (OneDrive/Google Drive link or similar)</P> Wed, 22 Nov 2023 20:16:16 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/MDURATION-function/m-p/3547528#M136430 OwenAuger 2023-11-22T20:16:16Z