Split plan details by month

Question

Hi ,&nbsp;Can anyone help me to spilit the 12 month plan details is included in a single column like revenue, cost , NIBIT etc.I want to spilit this column by assining months and see monthly plan details by category and the same i want to compare with actual to different table .Spiliting each plan column into 12 and unpivot the same making bit conufusion extracting months as one element for all category.https://1drv.ms/x/s!AjxQtWbPWyZDcKObDEgLrMFcPWQ?e=rdc6RO&nbsp;&nbsp;&nbsp;ThanksMani

allisonkennedy · Answer

Mani_msSorry, I don't understand what you're asking - is the attached file the raw data? What are you trying to achieve?

amitchandak · Answer

Mani_ms , refer if this file can help
https://www.dropbox.com/s/fnq82ksdzk1lqs3/Target_allocation_daily.pbix?dl=0
&nbsp;
Allocation happen from year to month and month to days
&nbsp;
or Value split between Dates
https://www.dropbox.com/s/yuv64v0cneseghx/value%20Split%20between%20months%20start%20end%20date.pbix?dl=0

Forum Discussion

Split plan details by month

2 Replies

Related content

Current month - YTD details

Split rows by month

Splitting Column values

Splitting column details

Missing Connection Details