Forum Discussion
Solved
Grab Value Other Table Between 2 Dates
I have two tables, and trying to grab the Period Name column into the main table based on being between the two dates Table FinPeriod Start Date | End Date | Period Name 2022-03-01 | 2022-04-10...
HI hsvjumper,
You can take a look at the following blog 'start date', 'end date' part if helps:
In addition, you can also try to create a new table to expand date ranges and mapping to raw table records:
Solved: Spread revenue across period based on start and en... - Microsoft Power BI Community
Regards,
Xiaoxin Sheng
As i understant, your period (month-yr) is based on start date so maybe you can pull the start date from the other table.