Populating dates between text data types

Question

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

amitchandak · Answer

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-or-end-date/ba-p/1503785

cnenfrnl · Answer

In theory, you can calculate the gap this way.

bblackwell3 · Answer

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

bblackwell3 · Answer

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

bblackwell3 · Answer

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

Forum Discussion

Populating dates between text data types

5 Replies

Related content

Population dynamic graaph

Date not populating

Selectedvalue Date Slicer not populating

Averages to populate in missing dates

Date Slicer should populate the date range using start date and end date columns using other slicers