Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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?
Solved! Go to 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...
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
@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...
Thank you, i found the solution following your article, especially the part where you show the relationships between dates tables.
User | Count |
---|---|
83 | |
77 | |
71 | |
69 | |
54 |
User | Count |
---|---|
105 | |
100 | |
91 | |
79 | |
68 |