Search found 8 matches

by omo
Thu Jun 22, 2017 8:08 am
Forum: PowerPivot/DAX
Topic: Is it possible to group dates into "Month - Year" format, without creating two separate groupings (by month and by year)
Replies: 6
Views: 2667

Re: Is it possible to group dates into "Month - Year" format, without creating two separate groupings (by month and by y

Ok, Phil, thank you. In fact I trusted pivot tables not to be able to do that as well as some other basic things.
by omo
Fri Jun 16, 2017 9:48 pm
Forum: PowerPivot/DAX
Topic: Is it possible to group dates into "Month - Year" format, without creating two separate groupings (by month and by year)
Replies: 6
Views: 2667

Re: Is it possible to group dates into "Month - Year" format, without creating two separate groupings (by month and by y

Here's the file. Note how the number of columns changes when the slicer is set to C or F. I need the number of columns to be the same all the time. Now right-click on Months and check "Show items with no data" and you end up with 24 months which I need even less. This is just a sample of d...
by omo
Fri Jun 16, 2017 7:33 am
Forum: PowerPivot/DAX
Topic: Is it possible to group dates into "Month - Year" format, without creating two separate groupings (by month and by year)
Replies: 6
Views: 2667

Re: Is it possible to group dates into "Month - Year" format, without creating two separate groupings (by month and by y

Sorry, I'll try to rephrase. I have some data for the period of November 2016 to April 2017 (daily). I need to group it in the pivot table. The usual grouping by month produces the following: Jan, Feb, March, Apr, Nov, Dec (in this order). This is pointless. I need to have this: Nov-2016, Dec-2016, ...
by omo
Tue Jun 13, 2017 11:06 pm
Forum: PowerPivot/DAX
Topic: Is it possible to group dates into "Month - Year" format, without creating two separate groupings (by month and by year)
Replies: 6
Views: 2667

Is it possible to group dates into "Month - Year" format, without creating two separate groupings (by month and by year)

The reason I don't want to have a separate year grouping is I have data from November-2016 to April-2017 and I want to show all months inside this period even if in some scenarios some months will have no data. But if I check "Use items with no data", I have the 24 months of 2016-17, which...
by omo
Sun Jun 11, 2017 12:23 am
Forum: Power Query
Topic: Some individual cells in the final output table need to be modified and survive through refresh
Replies: 7
Views: 3084

Re: Some individual cells in the final output table need to be modified and survive through refresh

Ok.
I realized that your approach works only if each row's unique identifier is located in the source tables (and this is often not the case, especially when there is more than one table). If instead of that you use an index column in Power query, the method will not work.
by omo
Sat Jun 10, 2017 10:58 pm
Forum: Power Query
Topic: Some individual cells in the final output table need to be modified and survive through refresh
Replies: 7
Views: 3084

Re: Some individual cells in the final output table need to be modified and survive through refresh

Matt, somehow I cannot replicate what you describe in your blog, the comments column gets duplicated (please see the file attached). For me the best solution would be this: add a column to the final table (the table produced by Power query). This column contains a formula, but there is hard-code in ...
by omo
Fri Jun 09, 2017 5:38 am
Forum: Power Query
Topic: Some individual cells in the final output table need to be modified and survive through refresh
Replies: 7
Views: 3084

Re: Some individual cells in the final output table need to be modified and survive through refresh

Phil and Matt, thank you for your detailed replies. Self referencing is really an ingenious method, both the variant suggested by Phil (as detailed, for example, here: https://blog.oraylis.de/2015/05/incremental-data-loads-in-microsoft-power-query-for-excel/) and by Matt. I have been checking them o...
by omo
Mon Jun 05, 2017 9:43 pm
Forum: Power Query
Topic: Some individual cells in the final output table need to be modified and survive through refresh
Replies: 7
Views: 3084

Some individual cells in the final output table need to be modified and survive through refresh

Here’s my workflow: I paste some data in several structured tables in a single excel file. I then create several queries from these tables, merge and append them and load the final table into a worksheet (all this within the same file). I then go over the final table and change the values in 3 or 4 ...

Go to advanced search