🔽More Info🔽
If you have a start date and end date but need to calculate how many people or items were present between those dates then you can use Power Query to help with this
This approach will work in Power BI and Excel
Source CSV file and Power BI solution is here
[ Ссылка ]
I've also done a video using DAX to solve this.
[ Ссылка ]
You may find the Power Query method means your data takes longer to refresh but there is likely an upside in the speed of your interactions between visuals in the report for your end users.
Find me on various social media platforms
[ Ссылка ]
Ещё видео!