Search found 5 matches

by Peter079
Fri Nov 29, 2019 8:32 pm
Forum: PowerPivot/DAX
Topic: Creating a forecast from Year To Date Values
Replies: 1
Views: 281

Creating a forecast from Year To Date Values

Hi, I am struggling to solve the following scenario. I have created a YTD measure that calculates actuals up to the end of a period e.g. November 2019, using the YTD function. My financial year end is March, and I am trying to figure out how I can add a Forecast Measure which is my YTD measure x 12/...
by Peter079
Mon Jul 23, 2018 10:28 pm
Forum: Power Query
Topic: Create connection only in Power BI Desktop
Replies: 1
Views: 1028

Create connection only in Power BI Desktop

Hi, I have used Power Query in Excel and make use of the only create connection followed by an append to create the table that I want. Is it possible to do the same thing (only create connection) in Power BI Desktop ? I can't find a create connection function. If not presumably it can still be achie...
by Peter079
Tue Feb 13, 2018 10:28 pm
Forum: PowerPivot/DAX
Topic: Only show Months for some Calculations
Replies: 1
Views: 1385

Only show Months for some Calculations

Hi Matt, you have provided me with invaluable assistance in the past, and I was hoping that you can solve the following: I have created a Pivot Table with measures for Actuals, Budgets, Actual YTD and Budget YTD. I am trying to create a report that shows Actuals by Month i.e. Jan, Feb, Mar etc and A...
by Peter079
Tue Jul 25, 2017 7:13 pm
Forum: Power Query
Topic: Custom Functions in Power Query
Replies: 2
Views: 2539

Re: Custom Functions in Power Query

Thanks Matt

As always you come up with an answer that makes sense
by Peter079
Mon Jul 24, 2017 8:18 pm
Forum: Power Query
Topic: Custom Functions in Power Query
Replies: 2
Views: 2539

Custom Functions in Power Query

Hi, I asked the same question at the Powerpivotpro forum but no response. My question is I have 8 accounting databases all set up in the same way (rows and columns). I have read a bit about custom functions in power query and its going over my head. The data does need a bit of work done to it before...

Go to advanced search