Search found 27 matches

by leimst
Thu Feb 01, 2018 6:26 am
Forum: PowerPivot/DAX
Topic: Text to Decimal
Replies: 1
Views: 906

Text to Decimal

Good Afternoon, I have a column in Excel that contains text and numeric data. I have Power Pivot linked to this table but found that it has set this particular column to text and will not allow the column to be changed to a numeric data type. This is problematic since I would like to sum the numbers...
by leimst
Thu Feb 01, 2018 5:40 am
Forum: Power Query
Topic: Data Normalization
Replies: 3
Views: 2019

Re: Data Normalization

Thank you for the high level summary Matt. Exactly what I needed.

leimst
by leimst
Thu Jan 11, 2018 9:18 pm
Forum: Power Query
Topic: Data Normalization
Replies: 3
Views: 2019

Data Normalization

Good Morning All,

Looking for a high level description of how to take a large flat table and divy it up into multiple tables, e.g. one fact table and multiple lookup tables, using Power Query.

Thank you in advance,

leimst
by leimst
Tue Oct 18, 2016 10:11 pm
Forum: Power Query
Topic: Populating blank cells based on previous rows
Replies: 2
Views: 1524

Re: Populating blank cells based on previous rows

Matt,

Thanks so much, that was exactly what I needed!

leimst
by leimst
Tue Oct 18, 2016 6:02 am
Forum: Power Query
Topic: Populating blank cells based on previous rows
Replies: 2
Views: 1524

Populating blank cells based on previous rows

Good afternoon all, I have attached a spreadsheet where the "LastName" column has an initial entry but then successive rows are blanks until a new "LastName" is populated thus indicating the end of the previous customer's sales and the beginning of a new customer's sales. Is ther...
by leimst
Thu Jun 09, 2016 4:40 am
Forum: PowerPivot/DAX
Topic: Logical DAX Equation
Replies: 4
Views: 2350

Re: Logical DAX Equation

Francesco, I get an error when attempting to use this formula, "Calculation error in measure 'Person_Data'[Chronically Homeless DAX]: A single value for column 'history_1 yearplus' in table 'Person_Data' cannot be determined. This can happen when a measure formula refers to a column that contai...
by leimst
Wed Jun 08, 2016 10:46 am
Forum: PowerPivot/DAX
Topic: Logical DAX Equation
Replies: 4
Views: 2350

Logical DAX Equation

Hello All, Using the following formula, I created the "Chronically Homeless?" column on the "person_data" tab: =IF(AND(OR([@[history_1 yearplus]]=1,[@[history_2 fourin3]]=1)=TRUE,LEN([@[Condition Data]])>1=TRUE)=TRUE,"Yes","No") I would like to create an equiv...
by leimst
Mon Jun 06, 2016 10:24 am
Forum: PowerPivot/DAX
Topic: Count of Groups
Replies: 3
Views: 1835

Re: Count of Groups

Thank you very much! This worked great!

leimst
by leimst
Mon Jun 06, 2016 6:13 am
Forum: PowerPivot/DAX
Topic: Count of Groups
Replies: 3
Views: 1835

Count of Groups

Hello All, I have data in the attached workbook from a survey. If there are multiple occurrences of a "survey_data_id" on the "person_data" tab then that means those individuals are in a family. There are a total of 38 individuals. 29 of them are in families and 9 are in single p...
by leimst
Thu Apr 21, 2016 3:09 am
Forum: Power Query
Topic: If/Then Equivalent in Power Query
Replies: 1
Views: 1742

If/Then Equivalent in Power Query

Hello All, I have attached a spreadsheet where I have a Status list in column A and a Category column in column B. I would like the Power Query equivalent of an Excel "If / Then" statement that would populate the Category column (column B) in accordance with the "Available Categories&...

Go to advanced search

cron