Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Creating a running total

I am trying to create a column that will display the running total for words. I am looking to sum the words for each vendor.   Example data vendor words Sent to Vendor anticipated delivery d...
Need Help
v-yuta-msft's avatar
v-yuta-msft
Community Support
7 years ago

Hi jarodjp42,

 

To achieve your requirement, create a calculate column using DAX below:

Column = CALCULATE(SUM(Table1[words]), FILTER(ALLEXCEPT(Table1, Table1[vendor]), Table1[Sent to Vendor] <= TODAY() && Table1[anticipated delivery date] >= TODAY()))

 

 

Regards,

Jimmy Tao

Anonymous's avatar
Anonymous
Not applicable
7 years ago

v-yuta-msft

 

Thank you for your reply. When I use the formula you provided it gives me an error saying that DAX comparison operations do not support comparing values to type text with values of type date. I went through to make sure all my date columns were data type: date and I'm still getting the error. Would the error be caused by the vendor column since it is text and there is no way to change it?

 

Thanks for your help

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    7 years ago

    Hi jarodjp42,

     

    Could you share your sample pbix file and clarify more details?

     

    Regards,

    Jimmy Tao