TOTAL PER MONTH

[Anonymous]

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               70

09/03/2021               32

I want to show the values ​​by month by measures or columns

MONTH                VALUE

Frebruary              121

March                   102

could you help me?

Thank you

[v-xiaotang · Accepted solution]

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]

@Anonymous Create this calculated column in your table:

Month = FORMAT([FECHA],"mmmm")

[Anonymous]

Hi

thanks for your time

LOG

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

☹️