## Search found 34 matches

Mon Jun 04, 2018 4:59 pm
Forum: PowerPivot/DAX
Topic: Time Intelligence webinar- Evaluation of Year to Date Totals
Replies: 5
Views: 373

### Re: Time Intelligence webinar- Evaluation of Year to Date Totals

Hi Matt, Sorry, I should have been more clear when I replied. I was just testing some stuff out to see try and see how the result changes with different formulas. I had a few measures without the ALL and MAX functions as well I will read your explanation a couple of times. Also been reading Rob Coll...
Mon Jun 04, 2018 2:47 pm
Forum: PowerPivot/DAX
Topic: Time Intelligence webinar- Evaluation of Year to Date Totals
Replies: 5
Views: 373

### Re: Time Intelligence webinar- Evaluation of Year to Date Totals

Hi Matt, Thanks for the blog. To be honest, I am still confounded by this. Everytime I think of the initial filter context affecting only the FILTER function as explained in your blog, the ALL function pops into my head and I think of the entire table and that really messes things up for me Going to...
Mon May 28, 2018 12:57 pm
Forum: PowerPivot/DAX
Topic: Time Intelligence webinar- Evaluation of Year to Date Totals
Replies: 5
Views: 373

### Re: Time Intelligence webinar- Evaluation of Year to Date Totals

Mon May 28, 2018 10:04 am
Forum: PowerPivot/DAX
Topic: Time Intelligence webinar- Evaluation of Year to Date Totals
Replies: 5
Views: 373

### Time Intelligence webinar- Evaluation of Year to Date Totals

Hi Matt, This is in reference to your recent time intelligence webinar https://www.youtube.com/watch?v=Ju_JURCHA6o&t=2395s (around the 40 min mark in the video) I am getting confused around how the filtering works in the evaluation of the Sales YTD code Sales YTD = Calculate ( [Total Sales],...
Tue Feb 13, 2018 11:38 am
Forum: PowerPivot/DAX
Topic: Slicer behaviour in Excel (Powerpivot) vs Power BI
Replies: 5
Views: 956

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

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

### 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
Fri Feb 09, 2018 3:04 pm
Forum: PowerPivot/DAX
Topic: Slicer behaviour in Excel (Powerpivot) vs Power BI
Replies: 5
Views: 956

### 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
Fri Feb 09, 2018 3:03 pm
Forum: PowerPivot/DAX
Topic: Slicer behaviour in Excel (Powerpivot) vs Power BI
Replies: 5
Views: 956

### 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...
Mon Oct 02, 2017 11:32 am
Forum: PowerPivot/DAX
Topic: Require Dax help with Years in Columns
Replies: 5
Views: 1850

### 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...
Thu Sep 28, 2017 8:28 am
Forum: PowerPivot/DAX
Topic: Require Dax help with Years in Columns
Replies: 5
Views: 1850

### 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}, {...