Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

TOTAL PER MONTH

Hello I want to show in a report the total loads per month I have this table   FECHA                      valor 02/02/2021               52 05/02/2021               69 04/03/2021            ...
General Comment
Need Help
Tips and Tricks
  • v-xiaotang's avatar
    v-xiaotang
    5 years ago

    Hi Anonymous 

    Based on your sample data, I created a sample under DQ mode, then

    1.  create a new table 

     

    Newtable = SUMMARIZE('Table',[FECHA],[valor],"month",FORMAT([FECHA],"mmm"))

     

    2. put it into table visual

     

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

Anonymous Create this calculated column in your table:

Month = FORMAT([FECHA],"mmmm")
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi

     

    thanks for your time

     

    LOG

    "The 'FORMAT' function is not allowed as part of calculated column DAX expressions in DirectQuery models."

     

    ☹️