Forum Discussion
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...
Hi IBrant ,
Try this :-
Iteration =
VAR _Date = [Date]
RETURN
CALCULATE(
MAX ( Iterations[FY] ),
Iterations[StartDate] <= _Date && Iterations[EndDate] >= _Date
)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
Iteration was not recognized in DAX or M. I also do not want it to calculate the number of FY, I want it to show the FY in the FY column. I will then be able to create many different visuals based on that information. For example, in the FY column, I would like to have FY22, FY23, etc returned based on the date in the Date_Onboard column.