Search found 30 matches

by masterelaichi
Tue Feb 13, 2018 11:38 am
Forum: PowerPivot/DAX
Topic: Slicer behaviour in Excel (Powerpivot) vs Power BI
Replies: 5
Views: 717

Re: Slicer behaviour in Excel (Powerpivot) vs Power BI

I created a Many-to-One relationship
by masterelaichi
Mon Feb 12, 2018 9:48 pm
Forum: PowerPivot/DAX
Topic: Slicer behaviour in Excel (Powerpivot) vs Power BI
Replies: 5
Views: 717

Re: Slicer behaviour in Excel (Powerpivot) vs Power BI

Thanks Ben, that is what I am not able to understand - why the slicers filter data in Power BI even when there is nothing added to the values field but in excel it does not unless the slicers are added from the same table
by masterelaichi
Fri Feb 09, 2018 3:04 pm
Forum: PowerPivot/DAX
Topic: Slicer behaviour in Excel (Powerpivot) vs Power BI
Replies: 5
Views: 717

Re: Slicer behaviour in Excel (Powerpivot) vs Power BI

Here is the second attachement which contains the excel file. It didn't allow me to attach 2 files for some reason
by masterelaichi
Fri Feb 09, 2018 3:03 pm
Forum: PowerPivot/DAX
Topic: Slicer behaviour in Excel (Powerpivot) vs Power BI
Replies: 5
Views: 717

Slicer behaviour in Excel (Powerpivot) vs Power BI

Hi, I am trying to understand the way slicers behave in Excel and in Power BI. I have two tables- a Lookup table and a fact table. There exists a relationship between DataTable_Letter --->LookTable_letter My question is when I add the DataTable_letter from the fact table to the Rows, and add a LookT...
by masterelaichi
Mon Oct 02, 2017 11:32 am
Forum: PowerPivot/DAX
Topic: Require Dax help with Years in Columns
Replies: 5
Views: 1455

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: 1455

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: 1455

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 59 times


Report - Correct.JPG
correct solution
Report - Correct.JPG (33.07 KiB) Viewed 1453 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: 1455

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: 1857

Re: Images

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

Images

Hi,
I have noticed people posting images of tables and relationships. How do I go about doing that? Any help will be appreciated

Go to advanced search