Forum Discussion

vijay273162's avatar
vijay273162
Icon for Helper III rankHelper III
4 years ago
Solved

TREATAS

HI All, Need to find previousmonth sales using TREATAS    below is the sample code......   Sales in previous month = VAR result1  = CALCULATE(SUM(Order[sales]),           TREATAS (VALUES (...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    Hi, vijay273162 

    TREATAS  is used to apply the result of a table expression as filters to columns from an unrelated table.

    You should make sure that here should be no physical relationship  between  Table "Orders" and Table "Delivery Dates Table".

     

    Best Regards,
    Community Support Team _ Eason

vijay273162's avatar
vijay273162
Icon for Helper III rankHelper III
4 years ago

If I use PREVIOUSMONTH in TREATAS, then..... I don't get any result in my table matrxi below.

 

 

So, I need to move the filter from delivery date table to order date table - at the sametime find the previousmonth data.

v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, vijay273162 

TREATAS  is used to apply the result of a table expression as filters to columns from an unrelated table.

You should make sure that here should be no physical relationship  between  Table "Orders" and Table "Delivery Dates Table".

 

Best Regards,
Community Support Team _ Eason