Forum Discussion

IBrant's avatar
IBrant
Frequent Visitor
3 years ago

If a date falls between dates, return a value

I'm new to Power BI and I'm struggling with what seems like a simple task. I need to sort dates by fiscal year. I've tried to do this a couple different ways.  1. I tried making a differnt column fo...
Need Help
pratyashasamal's avatar
pratyashasamal
Memorable Member
3 years ago

Use your table name place of TableName :-
Try this out if you want to return 0 or 1

 

Final =
VAR _Date = [Date] 
VAR Result =
    IF(TableName[StartDate] <= _Date && TableName[EndDate] >= _Date , 1, 0)
)
RETURN
    Result

If you want to return FY value :-

Final =
VAR _Date = [Date]
VAR Result =
IF(TableName[StartDate] <= _Date && TableName[EndDate] >= _Date , TableName[FY])
)
RETURN
Result

 

Thanks,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

 

IBrant's avatar
IBrant
Frequent Visitor
3 years ago

It isn't giving me an option to refer to another table for the start and end date range to return FY. I need it to look at the "Date Onboard" column and if that date is between 10/1/2021 and 10/1/2022, return FY22, if not return "". OR it can look at the seperate table I pasted above and return the FY if the "Date Onboard" is in the listed ranges on that other table.