Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago
Solved

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 ...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

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

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

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

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago

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:

NachoAl_0-1644498839192.png

As you could create the coumna date Quarter automatically, since the calendar is many years.

Thank you