Data Table: Columns per Week

[HenryJS]

Hi all,

How can I format my data to create a table like below on Power BI?

I need a column next to start and end date for each week. This would then relate to start and end date and be "Yes" if the week falls within the start-end date.

[V-lianl-msft]

Hi @HenryJS ,

If the data is the same as your screenshot, no suitable solution can be found for the time being in power bi ,you can vote for the idea mentioned by @amitchandak . If not, please show your data and expected results in more detail.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@HenryJS 

Seem like you are looking for hybrid table. Check for custom Table.

Vote for the Idea

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/39773011-hybrid-table

[Pragati11]

Hi @HenryJS ,

To answer your query, we need some screenshots around what data you are trying to format to the table in the screenshot.

Can you please add additional information here?

Thanks,

Pragati