Search found 26 matches

by masterelaichi
Mon Oct 02, 2017 11:32 am
Forum: PowerPivot/DAX
Topic: Require Dax help with Years in Columns
Replies: 5
Views: 278

Re: Require Dax help with Years in Columns

Thanks AndVGri I copied and pasted the code in the advanced editor. I am not sure if it was a case of the data source name getting changed. I am going through your solution which you have attached and trying to understand what you did. In the meantime, I have kept it simple by keeping the business u...
by masterelaichi
Thu Sep 28, 2017 8:28 am
Forum: PowerPivot/DAX
Topic: Require Dax help with Years in Columns
Replies: 5
Views: 278

Re: Require Dax help with Years in Columns

Hi I think it is better to split Amount per actual "Y" business unit per each year of Project Name. let Source = Excel.CurrentWorkbook(){[Name="Table3"]}[Content], Typed = Table.TransformColumnTypes(Source,{{"Project Name", type text}, {"FY16", Int64.Type}, {...
by masterelaichi
Wed Sep 27, 2017 12:26 pm
Forum: PowerPivot/DAX
Topic: Require Dax help with Years in Columns
Replies: 5
Views: 278

Re: Require Dax help

Continuing from my post above, I have attached a copy the excel file and also a screen grab of what the solution should look like
Report.xlsx
(277.67 KiB) Downloaded 10 times


Report - Correct.JPG
correct solution
Report - Correct.JPG (33.07 KiB) Viewed 276 times


I am going to be really embarrassed if the solution is something that is really obvious!!

Thanks again
by masterelaichi
Wed Sep 27, 2017 12:22 pm
Forum: PowerPivot/DAX
Topic: Require Dax help with Years in Columns
Replies: 5
Views: 278

Require Dax help with Years in Columns

Hi, I have a report which contains a number of Projects (which are actually tests), applied against a number of business units named Business Unit 1, Business Unit 2, etc. The report also contains, in individual columns, the funding for a specific financial year as shown in the image below Report.PN...
by masterelaichi
Wed Sep 27, 2017 10:59 am
Forum: Testing
Topic: Images
Replies: 2
Views: 170

Re: Images

Yes, in this forum. Maybe they were screen shots
Capture.PNG
Capture.PNG (2.2 KiB) Viewed 167 times
by masterelaichi
Wed Sep 27, 2017 9:37 am
Forum: Testing
Topic: Images
Replies: 2
Views: 170

Images

Hi,
I have noticed people posting images of tables and relationships. How do I go about doing that? Any help will be appreciated
by masterelaichi
Wed Aug 23, 2017 2:13 pm
Forum: PowerPivot/DAX
Topic: Recommended books / resources
Replies: 4
Views: 243

Re: Recommended books / resources

Thanks Matt. I'll check them out...
by masterelaichi
Tue Aug 22, 2017 8:57 pm
Forum: PowerPivot/DAX
Topic: Recommended books / resources
Replies: 4
Views: 243

Re: Recommended books / resources

Thanks Matt, I'll check out the books on your site. And yes, blogs are a good source of information. I follow yours besides a few others and try to learn via YouTube as well I have heard that the definitive guide by the Italians is a bit advanced. Would you suggest starting that for someone with bas...
by masterelaichi
Tue Aug 22, 2017 2:41 pm
Forum: PowerPivot/DAX
Topic: Recommended books / resources
Replies: 4
Views: 243

Recommended books / resources

Hi All, Not sure if this is where this post should go. I consider myself to be somewhere between a novice and intermediate user of DAX and Power BI/ Query Could you please suggest some books for dax and power query. I have your Matt's book as well as Power BI and Powerpivot by Rob Collie and Avi Sin...
by masterelaichi
Thu Aug 17, 2017 2:44 pm
Forum: PowerPivot/DAX
Topic: Project Status as of latest date
Replies: 5
Views: 295

Re: Project Status as of latest date

The code for the Variable measure does not align with the code for the 2 measure approach, using different tables and fields (see Date comparison at end of second measure). Could this be the reason? Hi Phil, Sorry, there was a typo in my code as I had to manually edit the column names to obscure it...

Go to advanced search