Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I am trying to calculate the days between a date and today but I don't succed...
I've created a new column :
DaysInWarehouse = DATEDIFF('caapps PackageHeader (2)'[WarehouseInDate];TODAY();DAY)
And I've got the following result:
WarehouseInDate DaysInWarehouse
2018-04-04 0
2018-04-03 20
2018-03-29 126
2018-03-28 238
What am I doing wrong?
Thanks in advance
// magnus
Solved! Go to Solution.
Hi @mrg64,
I have made a test by entering the date and creating the Calculated Column with your dax expression in Power BI Desktop (Version: 2.56.5023.942 64-bit (March 2018)), everything works as expected.
Please check if you have update to the latest Power BI Desktop and have a try.
What data source have you connected with and how to connected it?
If you connected by Direct Query, there should be some limitations.
If you need additional help , please share your data structure.
Best Regards,
Cherry
Hi @mrg64,
I have made a test by entering the date and creating the Calculated Column with your dax expression in Power BI Desktop (Version: 2.56.5023.942 64-bit (March 2018)), everything works as expected.
Please check if you have update to the latest Power BI Desktop and have a try.
What data source have you connected with and how to connected it?
If you connected by Direct Query, there should be some limitations.
If you need additional help , please share your data structure.
Best Regards,
Cherry
Hello I have followed the formula but the result shows negative
I'am trying do calculate number of days between today and a date but I don't succed...
I've created a column and defined number of days like this:
DaysInWarehouse = DATEDIFF('caapps PackageHeader (2)'[WarehouseInDate];TODAY();DAY)
I've got the following result:
WarehouseInDate DaysInWarehouse
2018-04-04 0
2018-04-03 20
2018-03-29 126
2018-03-28 238
..........
What am I doing wrong?
Thanks in advance
// magnus
You have aposterphies instead of commas..
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |