Search found 6 matches

by benholmes
Wed Feb 21, 2018 9:14 pm
Forum: PowerPivot/DAX
Topic: Dynamic calculation of Multiple Currency via slicer
Replies: 1
Views: 36

Re: Dynamic calculation of Multiple Currency via slicer

I'm only using Excel 2010 so can't look at your PP data model, however the attached file has a version that works. First I'd flatten your exchange rate table (I did this with the unpivot function in Power Query) so you've got 3 columns - Rate, Country/Currency and Rate - and add it, your sales table...
by benholmes
Wed Feb 14, 2018 8:31 am
Forum: PowerPivot/DAX
Topic: Only show Months for some Calculations
Replies: 1
Views: 87

Re: Only show Months for some Calculations

Assuming you want blanks for the YTD measures in the non 'last' months on your PT, one way would be to have a Boolean measure that checks if the month in the current row on the PT is the last month and then incorporate this into your YTD measure calcs. You could do this using ALLSELECTED on your Mon...
by benholmes
Tue Feb 13, 2018 5:50 am
Forum: PowerPivot/DAX
Topic: Slicer behaviour in Excel (Powerpivot) vs Power BI
Replies: 5
Views: 159

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

Having thought about it a bit more, I wonder if it's due to the fact you can setup relationships as many to many in PowerBI vs only one to many in Excel? Are your PBI relationships many to many?
by benholmes
Mon Feb 12, 2018 5:58 am
Forum: PowerPivot/DAX
Topic: datediff
Replies: 3
Views: 125

Re: datediff

You say you have a pivot table with those rows/values, what does the actual data table look like in PowerPivot (can you give some dummy or sample data)? And in terms of the calculation, is it literally just going to be the difference between the date in the current row displayed on the pivot and the...
by benholmes
Fri Feb 09, 2018 4:21 pm
Forum: PowerPivot/DAX
Topic: Slicer behaviour in Excel (Powerpivot) vs Power BI
Replies: 5
Views: 159

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

Can't comment on why there's a difference between Excel and PowerBI, as I haven't used the latter, however I believe the 'problem' in Excel is that until there's a measure placed in the PT nothingw ill be filtered (unless you physically make a filter selection on a row or column field), even if you ...
by benholmes
Thu Feb 08, 2018 11:50 am
Forum: PowerPivot/DAX
Topic: Dynamic Columns (slicer/mdx driven) not resizing
Replies: 0
Views: 89

Dynamic Columns (slicer/mdx driven) not resizing

Hi, Possibly not quite the right forum to post in (as it's possibly more an 'Excel' or perhaps MDX issue, but I expect this one probably has the most traffic so I'll give it a shot (plus it's a PP based PT, so it kinda fits). Anyway, I've got a PT with a number of slicers, some of which just filter ...

Go to advanced search

cron