Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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.
Then, create the groups as intended.
There isn't an option for weeks you can choose 28 days, that is similar time frame.
The result isn't exacly like you request but the result is.
Regards,
Sérgio Silva
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.
Then, create the groups as intended.
There isn't an option for weeks you can choose 28 days, that is similar time frame.
The result isn't exacly like you request but the result is.
Regards,
Sérgio Silva
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |