Certainly! Assuming you're working with Power BI, you can use a DAX measure to achieve this. Here's a step-by-step guide:
1. Load Data
First, make sure your data is loaded into a Power BI table. Let's call this table TrainingCourses.
2. Create a Measure
You can create a measure that checks if the expire date falls within the next week. This measure will return a "1" if the expiration date is within the next week and "0" otherwise.
Go to your TrainingCourses table and then click on New Measure.
Expiry_In_Next_Week =
VAR CurrentDate = TODAY()
VAR OneWeekLater = CurrentDate + 7
RETURN
IF(
AND([expire date] >= CurrentDate, [expire date] <= OneWeekLater),
1,
0
)
3. Filter Data
Now that you have the measure, you can create a visual (like a table) to show only those records where Expiry_In_Next_Week is 1.
Add a table to your report.
Drag the columns "first name", "Surname", "course date", and "expire date" to the values of the table.
Now, you can apply a filter to this table. Go to the filters pane, click on the measure Expiry_In_Next_Week, and set it to be equal to 1.
This table will now show only those people whose courses will expire within the next week.
Optional
If you want to highlight these dates or present them in a more visually appealing way, consider using Conditional Formatting.
