Populating dates between text data types

[bblackwell3]

Hey All. I have a SharePoint site that has Start and End dates for migrating applications. The values are not actually date types but have values for start and end dates such as <=2021, 2022 Q4 etc. I have been asked to produce bar chart visuals that count these applications in each respective year/quarter starting with their start date and ending at the end dates. My question is how to populate the "dates" in between the start and end dates, when they do not exist in the data? Two examples are below

[bblackwell3]

Forgot to add an excel representation of what I am trying to achieve

[CNENFRNL]

In theory, you can calculate the gap this way.

[bblackwell3]

Thanks and good idea. However, I don't need to identify a gap per se. I need to count each instance of application appearing during the gap, in the correct Year and Quarter

[amitchandak]

@bblackwell3 ,

You can refer if my blog on this topic can help

https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-o...

[bblackwell3]

Thanks for the reply. How can I use this logic when only have the Year and Quarter values available?