Spread weekly budget to day

[Anonymous]

I have a PowerBI file with a daily output query and a weekly budget. I have them linked with a seperate date query. Since my budget is only on a weekly basis, I am unable to drill down to days. In Excel this would be an easy fix, but is there an efficient way to just divide the weekly budget by 7 in PowerBI to display daily without adjusting the budget source? 

[V-lianl-msft]

Hi @Anonymous,

Could you share the sample pbix and the result you expect via cloud service like onedrive for business or image?

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

Probably but need sample data to test. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

I have done something similar here: https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Revenue-Reverse-YTD/m-p/373185#M111