Budgeting using TREATAS

DAX DAX Calculations
1

Hi Fellow Power BI Users -

Just wanted to get your advice on using TREATAS
In the below screen shot you show this by Month and Year. So i can using this function and show any visual by Month and Year only without making any other changes I am guessing??

Is it possible in the below function to add other field columns for “Quarter, Months”, Weeks"
With the knowledge that “Sales Budget” table has these fields inside them>

image
image.jpg892×177 52.7 KB

Thanks

2

Yes check out this tutorial for additional ways that TREATAS can be used.

https://blog.enterprisedna.co/2018/09/19/how-to-use-the-treatas-function-power-bi-and-dax/

The second example here I believe covers what you’re asking about.

For another tutorial on TREATAS see here.