Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
spandy34
Responsive Resident
Responsive Resident

Date Table - 4 week Period

Hi  wondered if you could help me.  I have a date table linked to a data table but I am wanting to present the following report that works in 4 week periods based on the Date of Visit.  What coding would I need to put in the column to look at the DateofVisit and put in the relevant period number outlined in the example below. If there are any other ideas as to how to present this please let me know.  

 

Thank you for your help

 

spandy34_0-1653318808871.png

@goncalogeraldes 

1 ACCEPTED SOLUTION
SergioSilvaPT
Resolver V
Resolver V

Hi @spandy34 ,

 

You can create a matrix with the dates in the columns, then click to show more options on the dates and chose New Group.

 

SergioSilvaPT_0-1653319617192.png

 

 

Then, create the groups as intended.

 

SergioSilvaPT_1-1653319688690.png

 

There isn't an option for weeks you can choose 28 days, that is similar time frame.

 

SergioSilvaPT_2-1653319762941.png

 

The result isn't exacly like you request but the result is.

 

Regards,

Sérgio Silva 

 
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

 

Regards,
Sérgio Silva

If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Check out my blog for tips and tricks about Power BI: https://pbibits.wordpress.com/

View solution in original post

1 REPLY 1
SergioSilvaPT
Resolver V
Resolver V

Hi @spandy34 ,

 

You can create a matrix with the dates in the columns, then click to show more options on the dates and chose New Group.

 

SergioSilvaPT_0-1653319617192.png

 

 

Then, create the groups as intended.

 

SergioSilvaPT_1-1653319688690.png

 

There isn't an option for weeks you can choose 28 days, that is similar time frame.

 

SergioSilvaPT_2-1653319762941.png

 

The result isn't exacly like you request but the result is.

 

Regards,

Sérgio Silva 

 
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

 

Regards,
Sérgio Silva

If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Check out my blog for tips and tricks about Power BI: https://pbibits.wordpress.com/

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.