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 m...
Need Help
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")
    )