Search found 31 matches

by AndVGri
Thu Sep 28, 2017 2:17 pm
Forum: PowerPivot/DAX
Topic: Require Dax help with Years in Columns
Replies: 5
Views: 4049

Re: Require Dax help with Years in Columns

Hi When I try to run this, it gives me an error "Table 3 wasn't found" Where did you try that? Is there a way to do this using dax? I think it is a bad way to do that in DAX. Because your transformation of data is incorrect as calculation source. You much times duplicate Amount of Project ...
by AndVGri
Wed Sep 27, 2017 10:30 pm
Forum: PowerPivot/DAX
Topic: Require Dax help with Years in Columns
Replies: 5
Views: 4049

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 AndVGri
Fri Sep 22, 2017 5:27 am
Forum: PowerPivot/DAX
Topic: Take the selected item in a slicer
Replies: 3
Views: 2823

Re: Take the selected item in a slicer

by AndVGri
Tue Sep 05, 2017 8:48 pm
Forum: Power Query
Topic: Update values from another table
Replies: 2
Views: 2858

Re: Update values from another table

Hi
You could use a such solution for updating with join by key new and previous price tables.
Regards,
by AndVGri
Mon Sep 04, 2017 6:33 am
Forum: PowerPivot/DAX
Topic: Trying to perform multi-step summary
Replies: 2
Views: 2379

Re: Trying to perform multi-step summary

Hi If you want I want to filter the sales table to only the first purchase for each customer, But if you sort your table by customers and purchase date you will see that only two products exist which customers purchased in first by date. You we have Excel 2016 such measure is simple =Var customerSta...
by AndVGri
Sun Sep 03, 2017 10:28 pm
Forum: Power Query
Topic: Table merging
Replies: 8
Views: 6354

Re: Table merging

Hi I think in that case Matt's algorithm is better. To do unpivot and after to do pivot again. let Source = Excel.CurrentWorkbook(){[Name="Table2"]}[Content], Unpivoted = Table.UnpivotOtherColumns(Source, {"Unique Column"}, "Attribute", "Value"), attrList = Li...
by AndVGri
Sun Sep 03, 2017 10:07 pm
Forum: PowerPivot/DAX
Topic: Iterating through Subsets to Find Previous Value
Replies: 8
Views: 5154

Re: Iterating through Subsets to Find Previous Value

Hi I suppose we can do that simpler = CALCULATE ( MAX ( 'Changes'[new_value] ), FILTER ( ALLEXCEPT ( 'Changes', 'Changes'[member_id] ), 'Changes'[change_type] = "Type" && 'Changes'[start_date] = CALCULATE ( MAX ...
by AndVGri
Thu Aug 10, 2017 5:25 pm
Forum: PowerPivot/DAX
Topic: Project Status as of latest date
Replies: 5
Views: 3574

Re: Project Status as of latest date

by AndVGri
Wed Aug 09, 2017 4:20 pm
Forum: Power Query
Topic: Speeding Up Custom Query - Unique Prefixer
Replies: 2
Views: 2627

Re: Speeding Up Custom Query - Unique Prefixer

Hi
Try do that with group algorithm.
Regards,
by AndVGri
Wed Aug 09, 2017 7:14 am
Forum: PowerPivot/DAX
Topic: Find unique customers who own multiple products
Replies: 5
Views: 3242

Re: Find unique customers who own multiple products

I'm pleased that the decision was suitable for you. I see you used DAX function, INTERSECT and NATURALINNERJOIN in your Excel then you can use VAR too.
Regards,

Go to advanced search

cron