MDURATION function

[Curiouslearner]

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

[OwenAuger]

Hi @Curiouslearner 

The MDURATION DAX function has the same specification as the Excel function, so for the same inputs you should see the same results.

Could you share an example PBIX file where you are seeing unexpected results? (OneDrive/Google Drive link or similar)