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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

vijay273162 , You should use date table, Try like

 

CALCULATE(SUM(Order[sales]),
TREATAS (PREVIOUSMONTH( 'Order-datetable'[date] ),
'Order-datetable'[date] )
)

or


CALCULATE(SUM(Order[sales]),
TREATAS (PREVIOUSMONTH( 'Date'[date] ),
'Order-datetable'[date] )
)

  • 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