Search found 885 matches

by MattAllington
Tue Nov 21, 2017 6:25 pm
Forum: Power Query
Topic: Using Parameters to select a column
Replies: 1
Views: 58

Re: Using Parameters to select a column

Hi Suzy

Do you have a sample you can post instead of the code? I haven't looked, but is there an end of month function in Power Query to find the last day of the current month eg EOM(Today()) [not real code] to work it out?
by MattAllington
Tue Nov 21, 2017 6:20 pm
Forum: PowerPivot/DAX
Topic: Average per month
Replies: 2
Views: 41

Re: Average per month

I've looked at this file and can't work out what you are trying to do. For me, the average per month is the running monthly total divided by the days. That is not what your excel sheet seems to do
by MattAllington
Tue Nov 21, 2017 6:06 pm
Forum: Power Query
Topic: Import from folder: use part of filename as value in addl. column
Replies: 2
Views: 23

Re: Import from folder: use part of filename as value in addl. column

Yes. What version of Excel do you have? Excel 2016 should do this almost automatically. Simply combine and edit. The auto process should add the source file name to the import. From there you can you extract the date information from the file name to use it in your table. Post back if that doesn't m...
by MattAllington
Mon Nov 20, 2017 6:30 pm
Forum: Power Query
Topic: Can I use ‘Enter Data’ to load old data once (incremental refresh)? [Solved]
Replies: 3
Views: 27

Re: Can I use ‘Enter Data’ to load old data once (incremental refresh)? [Solved]

Agreed - votes are important. It seems you have found the SOLVED feature :-)
by MattAllington
Mon Nov 20, 2017 7:05 am
Forum: PowerPivot/DAX
Topic: Calculated Column If Column Has A Value
Replies: 1
Views: 37

Re: Calculated Column If Column Has A Value

I am sure this can be done, but I am more interested as to why you want to do this. Power Pivot is very different to Excel, and maybe there is a better way to do what you want - I can't be sure because I don't know what you are trying to achieve.
by MattAllington
Mon Nov 20, 2017 7:00 am
Forum: Power Query
Topic: Can I use ‘Enter Data’ to load old data once (incremental refresh)? [Solved]
Replies: 3
Views: 27

Re: Can I use ‘Enter Data’ to load old data once (incremental refresh)? [Solved]

This feature is currently in planning https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/7288623-incremental-data-loads There is an option to turn off the query refresh for individual queries (include in report refresh). You could load a history file into Power BI and then turn off t...
by MattAllington
Sun Nov 12, 2017 11:37 am
Forum: PowerPivot/DAX
Topic: Growth Measure causing Relationship to break/change
Replies: 1
Views: 79

Re: Growth Measure causing Relationship to break/change

You need to understand how cross filtering behaviour works across relationships. I cover this specifically at my article here, but you may benefit from reading the whole article.

https://exceleratorbi.com.au/relationsh ... wer-pivot/
by MattAllington
Fri Oct 27, 2017 10:15 am
Forum: PowerPivot/DAX
Topic: DAX Formula
Replies: 1
Views: 168

Re: DAX Formula

Do you really need this in a column? How about using a measure? I answered a similar question here just yesterday https://www.mrexcel.com/forum/power-bi/ ... -date.html
by MattAllington
Fri Oct 27, 2017 6:24 am
Forum: PowerPivot/DAX
Topic: Count Down Over (remaining)
Replies: 1
Views: 81

Re: Count Down Over (remaining)

Firstly, if you ask the same question on two or more forums, you should cross link both. This is to stop 2 people providing effort and an answer in different places. https://www.mrexcel.com/forum/power-bi/1028575-count-down-over-remaining.html When using dax, you need to think about the table and ap...
by MattAllington
Tue Oct 24, 2017 4:13 pm
Forum: PowerPivot/DAX
Topic: Get a virtual table of dates from a selected date in a slicer
Replies: 3
Views: 168

Re: Get a virtual table of dates from a selected date in a slicer

OK, thanks for the further information. But I am not getting what you want to do with this table of previous months. Do you just want a list of months on the page? That doesn't sound very useful. Yes you could create a disconnected table to use as a slicer, and then harvest the selected value in tha...

Go to advanced search