Hi, I hope someone can help. I have a table containing our school term dates (start & end dates) and wish to flag which term is the current term based on this. Any help would be much apprectiated.
@gill_thornton , You can create a calculated column as per below DAX , fill free to update condition as per your requirements
DAX
CurrentTermFlag =
VAR CurrentDate = TODAY()
RETURN
IF(
CurrentDate >= TermDates[StartDate] && CurrentDate <= TermDates[EndDate],
"Current Term",
"Not Current Term"
)
Proud to be a Super User! | 
|
@gill_thornton , You can create a calculated column as per below DAX , fill free to update condition as per your requirements
DAX
CurrentTermFlag =
VAR CurrentDate = TODAY()
RETURN
IF(
CurrentDate >= TermDates[StartDate] && CurrentDate <= TermDates[EndDate],
"Current Term",
"Not Current Term"
)
Proud to be a Super User! |
|
Helpful resources
Power BI Dataviz World Championships
The Power BI Data Visualization World Championships is back! It's time to submit your entry.
Power BI Monthly Update - January 2026
Check out the January 2026 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
