Do you have an example of a format where Table 1 has only Budget data, and Table 2 has only Actual Data? I'm struggling to combine the tables via Relationships, Joins and Unions. I'd like to add additional tables as well to add "categories" to other existing fields. Thank you!
Do you have a video where you explain this in "tall format" i.e. example 1? I have a very large production dataset that is now requiring a MTD and YTD field with Budget and Actuals in a table. I Created a DATE measure that compares MONTH to TODAY()-1 (1 month in arrears) for MTD and a YTD with a similar funtion. The problem is, you can't have MTD and YTD in the same column (i.e., July can't be both MTD and YTD). I'm having an issue with this functionality (my MTD is good, and my YTD omits the current Month because that ROW is reserved for MTD in the column.
What if we are dealing with monthly data for actuals vs budget plus have other forecast scenarios to compare with actuals?.. how can this O/(U) br calculated using source 1?
Hey Jellyman! Absolutely love your videos - has helped me make a huge impact in my job. How hard would it be to do everything you did in this video, but instead using that first datasource that you used? If you have an email or phone # I can use to contact you directly (if you're down for that), would love to show you what I am working with and what I'm trying to do. Best, Clark
![Felix "Unfair" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/Oswujxm2Ag0/mqdefault.jpg)
extremely helpful do put more dashboards like this
Thanks Archi
Do you have an example of a format where Table 1 has only Budget data, and Table 2 has only Actual Data? I'm struggling to combine the tables via Relationships, Joins and Unions. I'd like to add additional tables as well to add "categories" to other existing fields. Thank you!
Do you have a video where you explain this in "tall format" i.e. example 1? I have a very large production dataset that is now requiring a MTD and YTD field with Budget and Actuals in a table. I Created a DATE measure that compares MONTH to TODAY()-1 (1 month in arrears) for MTD and a YTD with a similar funtion. The problem is, you can't have MTD and YTD in the same column (i.e., July can't be both MTD and YTD). I'm having an issue with this functionality (my MTD is good, and my YTD omits the current Month because that ROW is reserved for MTD in the column.
Nice job!!
Thanks!
What if we are dealing with monthly data for actuals vs budget plus have other forecast scenarios to compare with actuals?.. how can this O/(U) br calculated using source 1?
Hey Pooja, could you give me elaborate further please?
👌👌👌👌👌
Thanks Venkat!!!
spot on "Alabama" pronunciation 😂
HAHAHAHA!!!!! I was hoping at least one person found that funny so thanks Luke!!!!
Hey Jellyman! Absolutely love your videos - has helped me make a huge impact in my job. How hard would it be to do everything you did in this video, but instead using that first datasource that you used? If you have an email or phone # I can use to contact you directly (if you're down for that), would love to show you what I am working with and what I'm trying to do. Best, Clark
Hey Clark, glad you enjoyed. You can get in touch with me on guinto.jed@gmail.com
Looking forward to hearing from you