Forum Discussion

GuestUser's avatar
GuestUser
Icon for Helper V rankHelper V
6 years ago
Solved

Running Total Issue

Hi ,   Need help in creating running total column We are creating report using Connect Live option - SSAS Tabular   I have report in below format   Category  Name  Sales  RTotal ABC          ...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    6 years ago

    Hi, GuestUser 

    Please provide more details .（Where did you write your measure）

    Theoretically  no matter in the directquery  or live connect mode, Selectvalue function all can be recognized in  PowerBI Desktop.

     

     

    Best Regards,
    Community Support Team _ Eason

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

Sounds like you potentially need to switch Sales from being a Text field to a numeric field in your SSAS model.

GuestUser's avatar
GuestUser
Icon for Helper V rankHelper V
6 years ago

Sales is a measure column which is sum of sales_amount which is numeric only