Search found 5 matches

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

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 ...
by BINoob
Thu May 16, 2019 4:18 am
Forum: PowerPivot/DAX
Topic: Add multiple COUNTROWS in one expression [Solved]
Replies: 6
Views: 645

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
by BINoob
Wed May 15, 2019 9:09 am
Forum: PowerPivot/DAX
Topic: Add multiple COUNTROWS in one expression [Solved]
Replies: 6
Views: 645

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...
by BINoob
Wed May 15, 2019 8:29 am
Forum: PowerPivot/DAX
Topic: Add multiple COUNTROWS in one expression [Solved]
Replies: 6
Views: 645

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...
by BINoob
Tue May 14, 2019 6:15 am
Forum: PowerPivot/DAX
Topic: Add multiple COUNTROWS in one expression [Solved]
Replies: 6
Views: 645

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...

Go to advanced search

cron