Forum Discussion
Sum values when they match a condition format
Hello Greg, thanks for your reply!
I sliced a bit of the data so you can see its structure on the image below:
I'm taking a deeper look on summarize + addcolumns, this might actually solve this problem.
Thanks in advance!
Kind regards,
Murilo
Community ChampionAnonymous You will need to use SUMMARIZE or GROUPBY to group your rows by your columns, use ADDCOLUMNS or within the SUMMARIZE to calculate your value. You can then use another ADDCOLUMNS to count the number of OrangeDays. Hard to be specific.
Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
Hello Greg, thanks for your reply!
I sliced a bit of the data so you can see its structure on the image below:
I'm taking a deeper look on summarize + addcolumns, this might actually solve this problem.
Thanks in advance!
Kind regards,
Murilo