Forum Replies Created

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • August 14, 2019 at 12:41 am in reply to: Last Location Worked #18125

    brawnystaff
    Participant
    • Started: 0
    • Replies: 4
    • Total: 4

    Would need to created a Calculated Column for use in a slicer.

    See attached revision..

     

     

    Attachments:
    You must be logged in to view attached files.
    August 12, 2019 at 11:58 pm in reply to: Last Location Worked #18121

    brawnystaff
    Participant
    • Started: 0
    • Replies: 4
    • Total: 4

    See below

    Attachments:
    You must be logged in to view attached files.
    April 17, 2019 at 5:29 pm in reply to: First date in table #15512

    brawnystaff
    Participant
    • Started: 0
    • Replies: 4
    • Total: 4

    Regarding explaining the FIRSTNONBLANK line, the measure is similar to a nested formula in that TOPN operator is determining the top maximum value based on the criteria, the FIRSTNONBLANK operator is just ensuring the returned value is not a blank value.

    Regarding your second issue with not counting 0 values, if summing values, typically if summing a field 0’s would not be counted.  However, if doing a count, if would affect your results.  Would need you to upload a sample Excel workbook with sample data and expected results..

    April 11, 2019 at 8:15 pm in reply to: First date in table #15489

    brawnystaff
    Participant
    • Started: 0
    • Replies: 4
    • Total: 4

    See attached to get you started…

    Attachments:
    You must be logged in to view attached files.
  • Author
    Posts
Viewing 4 posts - 1 through 4 (of 4 total)