Search:

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

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Replies
    3
    Views
    251

    Re: Weighted Measure - Different Criterias

    Hi wornhall,
    Can you elaborate? I'm not sure how excel solver can help me here.

    I'm looking to create a Power BI measure utilizing the DAX language to calculate the Overall Score % for the 2 or...
  2. Replies
    3
    Views
    251

    Weighted Measure - Different Criterias

    Hello,
    I'm looking for help on creating a measure that give me an overall score based off of other score Metrics.

    I have 2 tables:
    First table provides the employee scores for the metrics being...
  3. Re: Matrix Table - Add Column to the end of the Matrix (not on every column)

    I have 2 tables:
    1) A custom date table that counts the aging starting with todays date as day 0, yesterday as day 1, day before yesterday Day 2, etc. etc.
    2) Ticket data containing the: client...
  4. Matrix Table - Add Column to the end of the Matrix (not on every column)

    Hey Guys,
    Looking for some help here - I havent been able to find a solution anywhere.

    I have a matrix table that provides a view of aging inventory. For each client they have a number of days...
  5. Re: Matrix with DoD (trending data) w/ 7 Day and 14 Day volume change

    Not in Excel.... I'm trying to build this in PowerBI, not sure if its possible---- I was utilizing the Matrix visual, but it does the calc/measure on each date when I only need it at the end (on the...
  6. Re: Matrix with DoD (trending data) w/ 7 Day and 14 Day volume change

    I may not be explaining correctly.... The measure works in that it gives me the volume difference between dates, but its doing the calculation for every date. I only want the last date to provide...
  7. Matrix with DoD (trending data) w/ 7 Day and 14 Day volume change

    Hey Guys,

    I cant figure out how to create a visual that shows day over day data with a 7 and 14 day volume change on the most recent date. I already created a measure to calculate the 7 and 14 Day...
  8. Weighted Average based on Field identifier

    Hey Guys,

    How would I create a measure of a weighted average based on 2 different field values? I know how to do this in excel using SUMPRODUCT, but I'm relatively new to DAX and dont know how to...
  9. Re: VBA - Open, Refresh, Send Attachment in Email, Save, and Close

    Thanks for the response, but I cant get this to work.... So here's what I'm doing, what I expect to happen and what is happening.....
    What I'm doing: I'm currently going into the workbook (w/no...
  10. VBA - Open, Refresh, Send Attachment in Email, Save, and Close

    Hey Guys,
    I'm looking for code that will allow me to set up a Task Scheduler that will open my excel file, wait about 10 seconds for the data to refresh (the data automatically refreshes upon open),...
  11. Re: PowerPivot - Import data and append new data on a daily basis

    That is correct, the previous days file is overwritten every day with a new file.

    Any idea on how to append these files into the data model?
  12. Re: PowerPivot - Import data and append new data on a daily basis

    Thanks for this info Matt, however, I'm not seeing exactly what I need.....I currently use PowerQuery to pull in a CSV report from a folder on the network. This report on the network is updated daily...
  13. PowerPivot - Import data and append new data on a daily basis

    Hey Guys (and Gals),

    I currently have a daily report that imports data (in table form) from a file that is placed into network folder every morning (I did this using Powerquery). So, everyday I...
  14. Re: Formula #REF error when updating a data table that holds less data (blank rows)

    Did you ever get a fix for this? I'm currently having the same issue...
  15. Re: Formula #REF error when updating a data table that holds less data (blank rows)

    Did you ever get a fix for this? I'm currently having the same issue...
  16. Replies
    5
    Views
    199

    Re: VBA/Macro help

    Awesome! This worked to perfection! thanks!
  17. Replies
    5
    Views
    199

    Re: VBA/Macro help

    Thank Joe4,
    I was actually going to go down this path so that I could try and automate the report. I was able to get our IT guys to drop the CSV files in a network folder so that I could pull the...
  18. Replies
    5
    Views
    199

    VBA/Macro help

    Hey Guys,

    I currently receive a CSV report in excel that contains "site ID's". Example of these Site ID's are: K7, CK055, CK056, NOV07, etc, etc.

    The problem is that all the site ID's that...
  19. Replies
    2
    Views
    100

    IF Statement help

    Hey Guys,
    How do I write an if statement that will calculate based on a letter that is in the cell?

    Example:
    I have a bunch of site ID's where some ID's end with the letter "M" and others do...
  20. Re: Conditional Formatting - Icon Sets w/Formula

    Thanks for taking the time on this Eric! I'm going to apply jtakw suggestion as I believe that is the easiest way to get this resolved.
  21. Re: Conditional Formatting - Icon Sets w/Formula

    Thanks jtakw!
    I'm going to try an apply this suggestion. I think it'll work.
  22. Re: Conditional Formatting - Icon Sets w/Formula

    Eric,
    Thanks for the suggestion, but I really need this to work with the Icon Set that looks like a traffic light. The reason for that is because my data is just a small set of data for a report...
  23. Conditional Formatting - Icon Sets w/Formula

    Hey Guys,
    Here's the situation: I have a list of clients that have satisfaction scores that I want to attach conditional formatting to (specifically a Icon set of Green, Yellow, Red). Simple enough...
  24. Replies
    5
    Views
    1,732

    Re: Year Formats Changing in GETPIVOTDATA

    Hi Claymationator -
    Were you able to find a solution to this problem? I'm having the exact same issue.

    Thanks!
  25. Replies
    0
    Views
    532

    Average YTD Calculation in PowerPivot

    Hey Guys,

    For simplicity sake lets assume I have this table of data: Name, Full Date, Month #, count (always equals 1)
    Each record in the table counts as 1 error.

    What I'm trying to do is get...
Results 1 to 25 of 40
Page 1 of 2 1 2