Forum Discussion
How do I create a relationship between months in one table and dates in another? DAX-PowerQuery
I have three data files that need to be part of the data model. DIMDATE, FORECAST, BUDGET. BUDGET is for Fiscal Year, has multiple countries and 2 divisions, an amount for most months, sometime the...
Good Day Rob,
Without looking at your data directly, I suggest that you try to split your monthly budget per country per division evenly by the number of days in the month to bring the Budget table to a daily "grain". For months where there is no budget for a particular division perhaps you could apply a business rule such as using last month's budget or similar. I have created a mock up in the Power BI file in the link below. I hope this helps.
Regards,
Jessica
https://drive.google.com/file/d/16Hq0OUqOvzxzm2iD3LsCtMpAlKB9_f4a/view?usp=sharing