Search found 5 matches

by Darko_Giac
Sat Jul 06, 2019 6:03 am
Forum: Power BI Desktop/Service
Topic: DAX: Highest Value by Date
Replies: 1
Views: 1199

DAX: Highest Value by Date

Hi all, I'm currently attempting to work through a DAX formula that will group my highest value and the date that highest value was submitted. My data set consists of Date Submitted, Bid, Room and Employee columns. The basic idea is that employees are bidding on certain rooms to rent out for the day...
by Darko_Giac
Sun Jan 20, 2019 5:17 am
Forum: PowerPivot/DAX
Topic: Count Frequency of Consecutive Specified Value
Replies: 0
Views: 683

Count Frequency of Consecutive Specified Value

Hi all, I'm currently working with a fairly large data set and am having some issue with a formula that will return the maximum frequency of a specified value that appears consecutively within a row. For example, respondent ID might have data that look like (where the values under Q1 through Q10 are...
by Darko_Giac
Mon Nov 26, 2018 2:14 am
Forum: PowerPivot/DAX
Topic: Creating Conditional Columns Filtered Within Rows
Replies: 2
Views: 769

Re: Creating Conditional Columns Filtered Within Rows

Thank you RamanaV! Worked like a charm!
by Darko_Giac
Sun Nov 25, 2018 1:39 am
Forum: PowerPivot/DAX
Topic: Creating Conditional Columns Filtered Within Rows
Replies: 2
Views: 769

Creating Conditional Columns Filtered Within Rows

Hello all, I'm wondering whether there is a way to create a gender flag (either through a measure or calculate column) that will flag mismatches in gender between the same ID. For example, My data are set up so that each ID has two entries, and ID101 for instance might have a gender of Male on one r...
by Darko_Giac
Thu Sep 07, 2017 4:50 am
Forum: PowerPivot/DAX
Topic: Creating a Flag for Mismatches
Replies: 1
Views: 1886

Creating a Flag for Mismatches

Hi all, I'm currently working with a fairly large data set of students in certain programs/disciplines, and would be looking to create a calculated column/flag that will identify students who are listed in a program but whose discipline name/ID doesn't match said program. I have attached a sample da...

Go to advanced search

cron