Forum Discussion

Minyun's avatar
Minyun
Frequent Visitor
4 years ago

Using TREATAS to dynamic budget granularity

Hi,   I am new to PowerBI and after reading through several articles I am still trying to wrap my head around the TREATAS function.   I have created a BudgetTable as below, listing budget values ...
v-cazheng-msft's avatar
v-cazheng-msft
Community Support
4 years ago

Hi Minyun 

 

Your description is quite clear and I've got what your problem is. Could you please tell me how you create relationships between Date table and table from MS SQL? If convenient, could you please provide a link of upload sample pbix file so we can do research on it to help you find the solution? Thanks in advance!

 

Best Regards,

Community Support Team _Caiyun Zheng

Minyun's avatar
Minyun
Frequent Visitor
4 years ago

Hi,

 

Thank you for responding. I am unable to share the .pbix.

 

The relationship between DateTable and MS SQL is using an additional column called DateJoin

 

DateJoin =

FORMAT(DateTable[Date], "YYYY")

&"-"&FORMAT(DateTable[Date], "MM")

&"-"&FORMAT(WEEKNUM(DateTable[Date],2),"00")

&"-"&FORMAT(DateTable[Date],"DD"))

 

This allows me to create 1 -> * relationship through all of my fact tables.

  • v-cazheng-msft's avatar
    v-cazheng-msft
    Community Support
    4 years ago

    Minyun 

     

    Sorry for the late response. I’ve tested at my side based on the information from you, but I can drill down with this Measure. Not sure whether there is any other factor caused this issue.

     

     

     

     

    Attached sample pbix file, it may help you find the cause.

     

    Best Regards,

    Community Support Team _ Caiyun

     

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