Make year span trimesters

[Cianfer]

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 has a filter year-trimester, needed to compare this year invoice vs previous year.

but because objectives has day and month when i apply those filters i have no data showed for the column objective if i don't select the 4th trimester.

how can i make that date column be considered the whole year? 

[v-shex-msft]

Hi @Cianfer,

Can you please explain more about your requirements? It will be helpful if you share some dummy data with the expected result to help us clarify your scenario.

How to Get Your Question Answered Quickly
Regards,

Xiaoxin Sheng

[amitchandak · Accepted solution]

@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-C...

or

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

[Cianfer]

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