Forum Discussion

Coelijoeli's avatar
Coelijoeli
Icon for Advocate I rankAdvocate I
11 years ago

Days between two dates columns

Hello community,   I'm building a dashboard with Power BI Desktop. I've connected a SQL server database which has two date fields:   [Transactiondate] [Closed]   What I want to do is get the ...
Need Help
Rémi's avatar
Rémi
Icon for Resolver III rankResolver III
11 years ago

Hi Coelijoeli,

 

When you do the difference, Power BI will keep the same format. Then you have to convert your result in order to obtain what you want.

 

Then you can add format function, or you can choose a number format into the top ribbon.

  • Haegi's avatar
    Haegi
    Icon for Advocate V rankAdvocate V
    11 years ago

    Hi,

     

    You can create a new measure with the dax formula by @Eno1978

     

    Regards.