Forum Discussion
Adapt Calendar
Hello everyone
I have three different fonts and I have created a calendar to join them, so far so good, it works. But one of the sources is quarterly and the other two are monthly. I want that when I make a filter and choose a month to see all the data, that the quarterly source shows me the last available data, and that the rest of the sources are shown the month that is selected. I do not find a fltro to do it, since with segmenter it goes blank in the quarterly when I choose a month that is not the one of the data.
If you can help me I appreciate it.
Bless you!!
You can deal with different calendar using closingbalance and date
Distributing/Allocating the Monthly Target(Convert to Daily Target): Measure ( Daily/MTD): https://community.powerbi.com/t5/Community-Blog/Power-BI-Distributing-Allocating-the-Monthly-Target-Convert-to/ba-p/1657798
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
closingbalancemonth ,closingbalancequarter, closingbalanceyear.
2 Replies
You can deal with different calendar using closingbalance and date
Distributing/Allocating the Monthly Target(Convert to Daily Target): Measure ( Daily/MTD): https://community.powerbi.com/t5/Community-Blog/Power-BI-Distributing-Allocating-the-Monthly-Target-Convert-to/ba-p/1657798
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
closingbalancemonth ,closingbalancequarter, closingbalanceyear.
Thanks for replying
Seeing what you have sent me, I think a solution is in the calendar table, which is per day, create a new column that puts me the equivalence of the day with the one that touches it in the quarter. I mean:
As you could create the coumna date Quarter automatically, since the calendar is many years.
Thank you
