cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Brainscand
Frequent Visitor

Help with filtering/ sum by a date from a summary table

Hello,

 

im a new user so please exuse my basic understandings to what may be a simple problem.

My issues is this

I have 2 tables 1 is a summary table that i am summarising total per day for a month. The issue i am having is sum the total of column A, column B is the date and there re mulitple of the same day. I need to return the sum of column A based on the date that is derived from the Summary table. Any suggested will be greatly apreciated.

 

Thanks

 

Daryl

2 REPLIES 2
Gokul_G16
Resolver I
Resolver I

Hi @Brainscand ,

Can please share the snap to better understanding your scenrio.

Option.
go to the modeling inside new table .
Then make it inquice summarzice value. 
= summarazice column ( table 1, column , column 2)..
. and  aside try to use the date formula for month. new column
= format (Date,"01-MM-YYYY"). this date formula is working by day wise data wil be calculating the month first date.

Regrds,
Gokulakannan. G

Mahesh0016
Solution Sage
Solution Sage

@Brainscand 
Total hours = 

SUM('ABCD - Лист1'[Hours])

 

Measure = SUMX(VALUES('ABCD - Лист1'[Date]),[Total hours])

Helpful resources

Announcements
Exciting changes

Power BI Community Changes

Check out the changes to the Power BI Community announced at Build.

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Kudo Data Story carousel

Data Stories Gallery

Visit our Data Stories Gallery and give kudos to your favorite Data Stories.

Top Solution Authors