cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AlexisPREVOT
Helper III
Helper III

Binning

Hi,

 

I am trying to use compartments against dates (groups by fourteen days).
I wanted to know if it was possible to postpone the groupings by 7 days so that the information provided correspond to the dates of my meetings.
For example I want the start of my first fortnight to start on January 11th. Is it possible ?
Thanks in advance.

 

Alexis

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@AlexisPREVOT , for date > 2021-01-11 you can do like

 

new column = quotient(datediff([date],date(2021,1,11),day),14)+1

 

or

new column if([date]>=date(2021,1,11) ,quotient(datediff([date],date(2021,1,11),day),14)+1 ,blank())



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@AlexisPREVOT , for date > 2021-01-11 you can do like

 

new column = quotient(datediff([date],date(2021,1,11),day),14)+1

 

or

new column if([date]>=date(2021,1,11) ,quotient(datediff([date],date(2021,1,11),day),14)+1 ,blank())



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Thank you @amitchandak

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!