Adapt Calendar

[Syndicate_Admin]

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!!

[amitchandak · Accepted solution]

@Syndicate_Admin ,

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

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

closingbalancemonth ,closingbalancequarter, closingbalanceyear.

https://www.youtube.com/watch?v=yPQ9UV37LOU

https://www.youtube.com/watch?v=6lzYOXI5wfo

[Syndicate_Admin]

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