Forum Discussion
Solved
Calculate days between two dates without duplicating days
Hi all! I have created a matrix with a summary of information, it has two date fields and a calculation of days using the DATEDIFF function. The problem is that I need to count the days without dupl...
I can't think of anything else other than using PQ to create rows of dates using the from and to date columns and then get the distinct count of those new dates so they are not counted multiple times in the total. Please see sample pbix.
danextian
Super User
Super UserMy only worry about that approach is the refresh might take a very long time on a large table. For a few thousand rows, the latency if there is should be negligible.
That's true. But I guess it is anyway a good approach since for other customers, I might be facing the same. I will start using a single file per customer and if needed, create a summary file in Excel. Thank you!