Forum Discussion

New Member

5 years ago

Solved

Make year span trimesters

Hello, i have a table with objectives: customer objective type date objective x a 31/12/2021 40% x b 31/12/2021 25% the main data table instead ...

Tutorial Requests

amitchandak
5 years ago
Cianfer , Based on what I got so far one of the two should help . You might only need CLOSINGBALANCEYEAR

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-Convert-to/ba-p/1476400

or

Distributing/Allocating the Yearly Target(Convert to Daily Target): https://community.powerbi.com/t5/Community-Blog/Distributing-Allocating-the-Yearly-Target-Convert-to-Daily/ba-p/1463290

Icon for Super User rank

Super User

5 years ago

Cianfer , Based on what I got so far one of the two should help . You might only need CLOSINGBALANCEYEAR

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-Convert-to/ba-p/1476400

or

Distributing/Allocating the Yearly Target(Convert to Daily Target): https://community.powerbi.com/t5/Community-Blog/Distributing-Allocating-the-Yearly-Target-Convert-to-Daily/ba-p/1463290

New Member

5 years ago

Thank you, i found the solution following your article, especially the part where you show the relationships between dates tables.