Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have data for the year but it is the same for each month:
Unit | 2021 |
A | 12 |
B | 14 |
C | 16 |
D | 18 |
Based on this data, I would like to add a column "month" from 01.2021 to 12.2021 and include the same value for each unit. There should be 48 rows in this example such as:
Unit | Month | Value |
A | 01.2021 | 12 |
A | 02.2021 | 12 |
A | 03.2021 | 12 |
A | 04.2021 | 12 |
A | 05.2021 | 12 |
A | 06.2021 | 12 |
A | 07.2021 | 12 |
A | 08.2021 | 12 |
A | 09.2021 | 12 |
A | 10.2021 | 12 |
A | 11.2021 | 12 |
A | 12.2021 | 12 |
B | 01.2021 | 14 |
B | 02.2021 | 14 |
B | 03.2021 | 14 |
.. | .. | .. |
Could I do it?
Thanks in advance.
Solved! Go to Solution.
@IF , I have two codes to see if that can help. Do not distribute
Distributing/Allocating the Yearly Target(Convert to Daily Target): Measure ( Daily/YTD): Magic of CLOSINGBALANCEYEAR With TOTALYTD/DATESYTD: https://community.powerbi.com/t5/Community-Blog/Power-BI-Distributing-Allocating-the-Yearly-Target-C...
Distributing/Allocating the Yearly Target(Convert to Daily Target): https://community.powerbi.com/t5/Community-Blog/Distributing-Allocating-the-Yearly-Target-Convert-to...
Both convert to dailt, you can convert to monthly
@IF , I have two codes to see if that can help. Do not distribute
Distributing/Allocating the Yearly Target(Convert to Daily Target): Measure ( Daily/YTD): Magic of CLOSINGBALANCEYEAR With TOTALYTD/DATESYTD: https://community.powerbi.com/t5/Community-Blog/Power-BI-Distributing-Allocating-the-Yearly-Target-C...
Distributing/Allocating the Yearly Target(Convert to Daily Target): https://community.powerbi.com/t5/Community-Blog/Distributing-Allocating-the-Yearly-Target-Convert-to...
Both convert to dailt, you can convert to monthly
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |