group by date and sum results

[mmm286b]

Hi 

I have these table:

I need to group by Date and sum the works in a table  like these:

How could I do these with PowerBi?

Thanks!

[Anonymous]

Hi, @mmm286b 

Thanks for FreemanZ's reply. Simply create the Table visual object and put the Date and Works fields into it.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[mmm286b]

Hi @Anonymous . I'm trying to generate line graph with total by date and total by server but don't works. It seems group by all month.

[Anonymous · Accepted solution]

Hi, @mmm286b 

Date fields can be grouped by day by following the settings below.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[mmm286b]

thanks! I'm tryng to generate graph line with these values, (works and sum of works by day) but I can't see anything in the graph:

[FreemanZ]

hi @mmm286b ,

you can plot a table visual with date column a measure like:

measure = SUM(data[WORKS])

or write a calculated table like:

Table = 

ADDCOLUMNS(

VALUES(data[date]),

CALCULATE(SUM(data[WORKS]))

)

or?

[mmm286b]

Thanks.

And If I would like to add in line graph.

How could I do that? 

[FreemanZ]

hi @mmm286b ,

try put date column to x-axis and the measure to y-axis.