Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Missing value

Hi guys,

 

I would like to calculate sum of "Transportation Charge" by againsted between month and previous month.

However, the result shows only "__TR Cost This Month" while the sum of previous month isn't display by monthly "__TR Cost Last Month".

 

Remark:  in the table, it has the sum total of "__TR Cost Last Month" which is correct result.

 

 

Please help me to find out this problem!

Thanks,

Billy.

Need Help

4 Replies

  • PijushRoy's avatar
    PijushRoy
    Community Champion
    2 years ago

    Hi Anonymous 

    is Unit (Adjust) measure? Please use column ref for filter
    Please create a table and check if there any value for your filter criteria "TR Change"
    In place of PARALLELPERIOD can you  use DATEADD


    Let me know if that works for you


    If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

    Thanks
    Pijush
    Linkedin

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi PijushRoy 

     

    Thank you for suggestion.


    The Unit (Adjust) is column.

    I've tried to use DATEADD instead of PARALLEPERIOD but result is still the same.

     

    Do you have any other solution?

     

    Thanks

    Billy

    • PijushRoy's avatar
      PijushRoy
      Community Champion
      2 years ago

      Hi Anonymous 

      Please share the DAX for "_TR Cost This Month"
      Try this, confirm that Date is date datatype

       

      _TR Cost Last Month = 
VAR _LastMonthSales = CALCULATE(
SUM([Value]),
FILTER('Append1','Append1'[Units (adjust)]="TR Charge"),
DATEADD('Append1'[Date],-1, MONTH)
)
RETURN _LastMonthSales

       

       


      Let me know if that works for you


      If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

      Thanks
      Pijush
      Linkedin

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Please find the DAX of "_TR Cost This Month" as below

         

        __TR Cost This Month =

        CALCULATE(
            SUM([Value]),
            FILTER('Append1', 'Append1'[Units (adjust)] = "TR Charge")
        )