Search:

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

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. 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. 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. 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 (
    ...
  4. Replies
    3
    Views
    133

    Re: Piovt Table Sorting

    Added the "s" and ran macro...Nothing..
  5. 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. 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. 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. 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. Replies
    5
    Views
    592

    Re: PowerPivot DAX Measure Error

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


    =CALCULATE(COUNTROWS(Table1),Filter(Table1,Table1[Acceptance]<>BLANK()&&Search("PO BOX",Table1[Address],1,0)>0))
  10. Replies
    5
    Views
    592

    Re: PowerPivot DAX Measure Error

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


    =CALCULATE(COUNTROWS(Table1),Filter(Table1,if(Table1[Acceptance]<>BLANK(),Search("PO BOX",Table1[Address],1,0)>0)))
    ...
  11. 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. Re: DAX/POWERPIVOT Count Number of Values That Contain Certain Text

    Hmm..download and gave the correct count. See link below...

    https://drive.google.com/open?id=1Yhjy9TddBO9jx-y-N2msSuaYv3P6LHYk
  13. 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. 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,...
  15. 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. 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. 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. 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. Replies
    1
    Views
    329

    Re: PowerPivot to Return Matching Records

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

    https://drive.google.com/open?id=1cpoQqj51XmXWe-VOtTiySci5qJnvwtk-

    Furthermore, I got the following code...
  20. 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. 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. Re: DAX Formula for last corresponding value in Max Date

    Excellent. That one did work. Thanks.
  23. 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. 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. 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 2 3 4