Forum Discussion
prakritnepal
Helper I
Helper Icumulative counts of data points between two dates
I am having trouble figuring out how to calculate and display the number of people that were on vacation on any given day. I have a SharePoint list with all the data. The data I am trying to use...
hi prakritnepal
Just use this logic to create a table
New table = FILTER(GENERATE('Table',CALENDARAUTO()),[Date]>=[start date]&&[Date]<=[end date])and here is sample pbix file, please try it.
Regards,
Lin
v-lili6-msft
Community Support
Community Supporthi prakritnepal
Just use this logic to create a table
New table = FILTER(GENERATE('Table',CALENDARAUTO()),[Date]>=[start date]&&[Date]<=[end date])
and here is sample pbix file, please try it.
Regards,
Lin
prakritnepalHelper I
Helper IThank you. That worked