Search:

Type: Posts; User: brawnystaff; Keyword(s):

Page 1 of 4 1

1. Thread: Power Pivot or Power Query to show all claim lines for a customer with a specific event

by brawnystaff
Replies
1
Views
99

Power Pivot or Power Query to show all claim lines for a customer with a specific event

I have a spreadsheet with multiple claim lines per day for various events taking place per customer.

I am looking for either a Power Query or Power Pivot solution to show all claim lines for...
2. Thread: Convert DAX Calculated Column to a Measure

by brawnystaff
Replies
3
Views
1,023

Re: Convert DAX Calculated Column to a Measure

Thanks MrVillareal. It worked!! Tried using a SUMX expression and just wan't working..this would did..
3. Thread: Convert DAX Calculated Column to a Measure

by brawnystaff
Replies
3
Views
1,023

Convert DAX Calculated Column to a Measure

Trying to convert a DAX Calculated Column to a Measure with no luck. Any ideas? See below and attached. Thanks.

=CALCULATE (
DISTINCTCOUNT ( Table1[Patient ID] ),
FILTER (
...

by brawnystaff
Replies
3
Views
133

Re: Piovt Table Sorting

Added the "s" and ran macro...Nothing..

by brawnystaff
Replies
3
Views
133

Piovt Table Sorting

I use the macro below to sort a Pivot table descending based on the value cell I have selected in Pivot Table value section, regardless of how many Row Labels there are. It works for a standard...
6. Thread: Transform table with Pivot Table, DAX formula

by brawnystaff
Replies
4
Views
583

Re: Transform table with Pivot Table, DAX formula

Your right, that example was not as good..

Was able to find a better one at URL below, but only deals with one column vs. your two..
...
7. Thread: Transform table with Pivot Table, DAX formula

by brawnystaff
Replies
4
Views
583

Re: Transform table with Pivot Table, DAX formula

Probably with Power Query...

https://www.thebiccountant.com/2019/02/28/unstacking-columns-in-power-bi-power-query-excel/
8. Thread: PowerPivot DAX Measure Error

by brawnystaff
Replies
5
Views
592

Re: PowerPivot DAX Measure Error

Was able to change on my end with both DAX formulas with no problems. Maybe a formatting issue with your data.
9. Thread: PowerPivot DAX Measure Error

by brawnystaff
Replies
5
Views
592

Re: PowerPivot DAX Measure Error

Was able to shorten it and get rid of the If statement using following syntax:

10. Thread: PowerPivot DAX Measure Error

by brawnystaff
Replies
5
Views
592

Re: PowerPivot DAX Measure Error

Using previous example where it is called Table1, DAX would look like this:

...
11. Thread: DAX/POWERPIVOT Count Number of Values That Contain Certain Text

by brawnystaff
Replies
10
Views
858

Re: DAX/POWERPIVOT Count Number of Values That Contain Certain Text

Hard to say...although I note that your formatting in cells is inconsistent, as although it says "General" for all, some numbers appear to be formatted as Text (justification to left instead of...
12. Thread: DAX/POWERPIVOT Count Number of Values That Contain Certain Text

by brawnystaff
Replies
10
Views
858

13. Thread: DAX/POWERPIVOT Count Number of Values That Contain Certain Text

by brawnystaff
Replies
10
Views
858

Re: DAX/POWERPIVOT Count Number of Values That Contain Certain Text

Assuming zip codes were in their own cell, for one value at at time, it would be as follows:

=CALCULATE(COUNTROWS ( Table1 ),FILTER( Table1,If( LEFT(Table1[Zip],1)="1",1, 0 ) > 0 ))

However,...
14. Thread: DAX/POWERPIVOT Count Number of Values That Contain Certain Text

by brawnystaff
Replies
10
Views
858

Re: DAX/POWERPIVOT Count Number of Values That Contain Certain Text

Chose the table name "Table1" and used SEARCH instead of FIND (SEARCH is not case sensitive):

=CALCULATE (
COUNTROWS ( Table1 ),
FILTER ( Table1, SEARCH ( "PO BOX", Table1[Address], 1,...

by brawnystaff
Replies
6
Views
247

Re: Logged hh:mm:ss reading as a timestamp in Excel

Regarding your issue with #1 , convert time to seconds, sum, then convert sum to h:mm:ss. If A1 has your value, formula would be as follows:

=A1*24*60*60

Thus, 00:01:41 would become 101 (101...
16. Thread: Excel 2019 Power Pivot

by brawnystaff
Replies
0
Views
1,333

Excel 2019 Power Pivot

Microsoft has released an Office 2019 preview for business. I looked under the what's new section for Excel, and it says "PowerPivot enhancements". Does anyone know what those enhancement are? ...
17. Thread: Difference in DAX between Excel Versions

by brawnystaff
Replies
1
Views
287

Re: Difference in DAX between Excel Versions

Should function the same in both versions. However, I recently had the same problem with using count for a numeric value that was giving me an error, then realized the numeric value was formatted as...
18. Thread: Power pivot formula - find max price with conditions

by brawnystaff
Replies
5
Views
460

Re: Power pivot formula - find max price with conditions

What version of Excel are you using? Are you looking for a measure or calculated column?
19. Thread: PowerPivot to Return Matching Records

by brawnystaff
Replies
1
Views
329

Re: PowerPivot to Return Matching Records

Allright, I made some corrections to the workbook (wrong relationship). See link below:

Furthermore, I got the following code...
20. Thread: PowerPivot to Return Matching Records

by brawnystaff
Replies
1
Views
329

PowerPivot to Return Matching Records

I have a data in two different worksheets/tables that I am trying to match up the unique IDs and dates of service and return the corresponding claim number. One table lists a specific date in one...
21. Thread: Excel 2016 and DAX Formula in Pivot Table

by brawnystaff
Replies
1
Views
396

Excel 2016 and DAX Formula in Pivot Table

I am using Excel 2016 Pivot tables/Data Model option and am trying to insert a DAX measure to get the day of the week for a date. The formula should be
=Format([Date],"DDDD") but when I try it I...
22. Thread: DAX Formula for last corresponding value in Max Date

by brawnystaff
Replies
4
Views
6,184

Re: DAX Formula for last corresponding value in Max Date

Excellent. That one did work. Thanks.
23. Thread: DAX Formula for last corresponding value in Max Date

by brawnystaff
Replies
4
Views
6,184

Re: DAX Formula for last corresponding value in Max Date

Hmm. Variable "Last Date" worked and displays the last date, but last status comes back blank. When measure was created, no errors were displayed.

I uploaded a sample file at the following URL:
...
24. Thread: DAX Formula for last corresponding value in Max Date

by brawnystaff
Replies
4
Views
6,184

DAX Formula for last corresponding value in Max Date

I am using Excel 2016 and have the following three columns in a worksheet:

Column A: Name
Column B: Date
Column C: Status Code

There are duplicate names that appear in Column A, what changes...
25. Thread: VBA - Extract data from Acrobat PDF using Excel

by brawnystaff
Replies
0
Views
2,316

VBA - Extract data from Acrobat PDF using Excel

I have Excel 2016 and Acrobat XI Pro

I have a multi-page PDF with various non-sequential serial numbers (Bates numbers) at the bottom of each page. The syntax for each serial number is ABC-XXX...
Results 1 to 25 of 81
Page 1 of 4 1