Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 difference between these two in days.
I tried a DAX measure to find the difference( Closed - Transactiondate), but this gives me a weird date value.
Can someone help me with this problem?