## Search found 5 matches

Thu Jun 06, 2019 12:40 am
Forum: PowerPivot/DAX
Topic: Measure - Month to Date Weekday Count
Replies: 1
Views: 305

### Measure - Month to Date Weekday Count

I have various Measures created. There are a couple of them that I would like to divide by the number of Weekdays (workdays) that have passed Month to Date so that I can get the average per workday. How would I be able to work that in to an existing Measure? Do I have to work that in to the Measure ...
Thu May 16, 2019 4:18 am
Forum: PowerPivot/DAX
Topic: Add multiple COUNTROWS in one expression [Solved]
Replies: 6
Views: 921

### Re: Add multiple COUNTROWS in one expression[Solved]

Hey Phil,

Thank you very much! The unpivoted columns allowed me to use a single Measure to divide two calculated countrows statements to get the percentage. This was an elegant and simple solution compared to what I thought I was facing.

Who da man? You da man!

John
Wed May 15, 2019 9:09 am
Forum: PowerPivot/DAX
Topic: Add multiple COUNTROWS in one expression [Solved]
Replies: 6
Views: 921

### Re: Add multiple COUNTROWS in one expression[Solved]

Phil, Ahhh...the dust is burning off of the gears. That puts the information in a much better perspective with regards to how to prep and manage the data. This makes those columns much more manageable. The nulls are not counted, but having everything in one column give options to get around those pr...
Wed May 15, 2019 8:29 am
Forum: PowerPivot/DAX
Topic: Add multiple COUNTROWS in one expression [Solved]
Replies: 6
Views: 921

### Re: Add multiple COUNTROWS in one expression[Solved]

Hi Phil, Forgive me if I take the Noob of the year award here. I can use Power Query to transform the data, but not sure how to do that effectively. I have 12 columns and several possibilities per column to account for and everything I can think of seems like 24 measure to create. Here is a sample o...
Tue May 14, 2019 6:15 am
Forum: PowerPivot/DAX
Topic: Add multiple COUNTROWS in one expression [Solved]
Replies: 6
Views: 921

### Add multiple COUNTROWS in one expression[Solved]

I did some searches, but I think I'm just not entering the right search string. I may even be barking up a the wrong tree here. I have a table with 12 different columns that could be any number between 1 and 5 or could be "null". I want to be able to count the number of fields in each colu...