cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Route217 Member
Member

Sum, agregrate muliple date values into a single value

Hi Experts

Having a great deal of difficulty in adding up mutilple dates with the same date stamp into one single value
Column A Column B
March 2017 1
March 2017 2
March 2017 4

Currently this is what I see in the master table.... would like to add the date table format in power bi so the end user see.
March 2017
Column b 7

And so on for other periods...across the columns for any year..
1 ACCEPTED SOLUTION

Accepted Solutions
rajendran Super Contributor
Super Contributor

Re: Sum, agregrate muliple date values into a single value

Hi

 

Have the date and column B in your Table visual.Right click Columnb in "Values" and select Sum, this will Group and sum .

 

Sum.PNG

 

Thanks

Raj

View solution in original post

9 REPLIES 9
Route217 Member
Member

Sum dates based on dates seleted on slicer

Hi Experts

How would you calculate the row count for two date parameters based on a filter on a second column

So....I would like to know the count of values between 1.1.2016 to 1.1.2017 where the value of OHA is true in the OHA column.
Route217 Member
Member

Re: Sum dates based on dates seleted on slicer

Apologies forgot to mention the dates are in the same column called datecteateddate
rajendran Super Contributor
Super Contributor

Re: Sum dates based on dates seleted on slicer

Can you please post some sample data with expected result?

 

Thansk
Raj

Route217 Member
Member

Re: Sum dates based on dates seleted on slicer

Sorry cannot post a same file from my location even with dummy data...

What I have in mind was
= calculate (countrows(case date),case date[oha] = "true", filter ( here should be the date ranges) using AND...this is where I got stuck..

If this is the correct way in DAX to write the function..
rajendran Super Contributor
Super Contributor

Re: Sum, agregrate muliple date values into a single value

Hi

 

Have the date and column B in your Table visual.Right click Columnb in "Values" and select Sum, this will Group and sum .

 

Sum.PNG

 

Thanks

Raj

View solution in original post

Route217 Member
Member

Re: Sum, agregrate muliple date values into a single value

Thanks Raj...I'll test and post back here
Route217 Member
Member

Re: Sum, agregrate muliple date values into a single value

Hi Raj

 

Followed your instruction and it does not give me the option to sum just count and distinct count.. abit surprised myself...

Capture.PNG

 

rajendran Super Contributor
Super Contributor

Re: Sum, agregrate muliple date values into a single value

I think the column is defined as text. Please convert the column type to Numeric, you will get the SUM options.

 

Thanks
Raj

Route217 Member
Member

Re: Sum, agregrate muliple date values into a single value

Sorted...Thanks

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Users Online
Currently online: 454 members 4,275 guests
Please welcome our newest community members: