Search found 236 matches

by PhilC
Wed May 15, 2019 9:24 am
Forum: PowerPivot/DAX
Topic: Add multiple COUNTROWS in one expression
Replies: 6
Views: 91

Re: Add multiple COUNTROWS in one expression

Hi John, Great, let us know how you go. Regarding the nulls, if the cell is actually null, it drops off the rows when you Unpivot, so they will not be in the table anymore. If you need them for the counts, you would need to replace with a 0 or other value prior to Unpivoting. You can do this and sti...
by PhilC
Wed May 15, 2019 9:04 am
Forum: Power Query
Topic: Sum of a column
Replies: 8
Views: 132

Re: Sum of a column

Hi luca, Do you need a calculated column? What will be your use of this calculation? Have a read of Matt's post here: https://exceleratorbi.com.au/calculated-columns-vs-measures-dax/ Work out if you really need a calculated column or if the solution can be made with measures. Maybe provide some deta...
by PhilC
Wed May 15, 2019 8:59 am
Forum: PowerPivot/DAX
Topic: Greyed out table columns
Replies: 2
Views: 45

Re: Greyed out table columns

Are the columns hidden from Client View?

Right click on the column and see if you can "Unhide from Client Tools"
by PhilC
Wed May 15, 2019 8:58 am
Forum: PowerPivot/DAX
Topic: Add multiple COUNTROWS in one expression
Replies: 6
Views: 91

Re: Add multiple COUNTROWS in one expression

Hi BINoob, Certainly nothing Noobish about asking how to achieve something. Like Excel, with Power Query / Power Pivot, there are usually multiple ways to achieve something. So, it sounds like manipulating the data prior to loading into Power PIvot is an option. Much of what you read from people lik...
by PhilC
Tue May 14, 2019 3:41 pm
Forum: Excel
Topic: "ThisWorkbookDataModel"
Replies: 1
Views: 260

Re: "ThisWorkbookDataModel"

by PhilC
Tue May 14, 2019 12:32 pm
Forum: PowerPivot/DAX
Topic: Add multiple COUNTROWS in one expression
Replies: 6
Views: 91

Re: Add multiple COUNTROWS in one expression

Hi BINoob, Are you able to use Power Query to transform the data? ie Unpivot the 12 columns, which I assume are months of the year? https://community.powerbi.com/t5/Desktop/Help-Count-with-condition-across-column/td-p/140881 If not, in the same link there is a formula you could use as a calculated c...
by PhilC
Sun May 12, 2019 9:29 pm
Forum: Power BI Desktop/Service
Topic: Comparison between Power BI and Tableau software
Replies: 2
Views: 61

Re: Comparison between Power BI and Tableau software

A Google search will provide lots of comparisons, though check the date as things change over time.

Here is one :
https://youtu.be/FoqSPCtj7zo

Cheers
Phil
by PhilC
Fri May 10, 2019 8:09 pm
Forum: PowerPivot/DAX
Topic: This formula will not display a visual
Replies: 1
Views: 65

Re: This formula will not display a visual

You do not have a aggregator function in the formula at all, guessing SUM is the most likely one.

Change the ALL to SUM and see if that works.

Cheers
Phil
by PhilC
Thu May 09, 2019 11:33 am
Forum: Power Query
Topic: Unpivot Columns
Replies: 3
Views: 209

Re: Unpivot Columns

Ah, apologies for that, do not pick that aspect up.

Go to advanced search

cron