need help

  1. S

    Need help DAX LOOKUP formula which would work like VLOOKUP

    Hello Everyone, I have two tables Table 1:- Voucher No. Invoice No. Invoice Amount Invoice Date Vendor Name 1 ABC-1 100 14/05/2019 ABC Company 1 ABC-2 200 14/05/2019 ABC Company 2 EFG-1 300 31/05/2019 EFG Company 2 EFG-2 400 31/05/2019 EFG Company 3 XYZ-1 500 30/06/2019 XYZ...
  2. S

    Need help of Date Format

    Hello Everyone, Is there a way to show a date as "MM-YYYY" format in power query or in DAX. The actual data is in "DD/MM/YYYY" format. Thanks in advance. Best Regards,
  3. S

    Copy data from two different sheets

    Hello Everyone, I have two sheets with follow data: Sheet 1 SR. No Data 1 A 2 B 3 C 4 D 5 E 6 F 7 G 8 H Sheet 2 SL. No Data 1 100 2 200 3 300 4 400 5 500 6 600 7 700 8 800 I am looking for a formula/way to copy data from above sheets to a third...
  4. L

    "Translation" of Excel formula into M language for the Power Query Editor

    Hi guys, I am totally new to Power BI, the Power Query Editor and most of all the M language. I wanna try to import data from different Excel documents using the Power Query Editor and then merge different columns from these separate documents using the joins function. Finally, I plan to add...
  5. L

    Drill through y-axis on stacked column chart

    Hello, I have a stacked column chart with dates on the x-axis and different codes on the y-axis. I would like to set-up a drill through / drill down function for the codes on the y-axis but I don't know how to do this. For example, one of the stacked column is the code "3xx". This code is...
  6. J

    Need Help?? (Not sure what function to use)

    Hi, I am trying to write a formula that will tell me if a client is new or existing. Below is some sample data of the file I am working with. <colgroup><col><col><col span="25"></colgroup><tbody> Client New/Existing Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17...
  7. K

    Filter and copy table

    Hi All, I am struggling with copying over a filtered table from one workbook to another. the workbooks are both open. The table is in the commission tab in the Sales Master - 2018.xlsm file So, I need to filter the table to show all the data of the name of the person at the end of the...
  8. J

    Color of Text in Formula Bar is Black -- Need Color

    Hi all, I just upgraded to Win 10 and Excel 2016 (64 bit), was previously on Win 7 and Excel 2013. I disable "allow editing directly into cells" within the options so that all my editing is done in the formula bar. In Excel 2013, when pressing F2 to edit a formula, the font would change color...
  9. T

    Timeline Slicer - how to link it

    Hey guys, I'm totally new to Power BI and currently stucked with my work... For you it might only take a few minutes, but for me it would mean a forune! What I would like, to have a slicer that starts from "Service Created". So I only see the Services that has been created before the chosen...
  10. J

    Replacing unknown values/text in the same cell as a known word

    Hey you all, I am pretty much a newbie to the whole Excel macro area and I tried my best to Google the answer for my problem but couldn't quite find a satisfying solution to it. So what I am trying to do is to censor all names from an Excel file by replacing the very next word of "herr", and...
  11. C

    Lead Time Calculations

    I can't seem to figure out a formula for this. Please help! I want it to count business working days in numerical output for when I should Order the part based on the date I open the excel file compared to Due Date with Lead Time. <tbody> A B C Program Due Date <colgroup><col width="64"...
  12. O

    Prorating savings based on number of months in a quarter

    Hi All i need with a formula to do the following calculation 1 determine the quarter that a date falls in and then compare it to the last quarter of the year. 2. Determine the number of months in each quarter and then prorate an amount based on the number of month in each quarter. for example...
  13. F

    Count Values Greater Than Measure Average

    Hi, I have this example in my onedrive. Link:!As8YC7wZr8RKist1_Ql70SsOKar7yA I create the measure MEDIAN. I would like to count how many itens in the Subcategory column Greater Than the MEDIAN. Could this calculation be done as a measure, not column?
  14. F

    PERCENTILE.INC for each category

    Hi, Here is an example with my challenge click (onedrive files) I following cues from and ERRATA I am trying to get...
  15. F

    Percentile 80 in Dax (Excel 2013 Version)

    I have this sort of table below and I'd like to calculate percentile 80 to "qtd/cons" for each category in "Col1" as a calculated column. Col1 qtd cons qtd/cons <tbody style="border: 0px...
  16. B

    3D Map 2016 Excel

    Zip Codes, the New England section of the United States where the zips are truncated in excel like 01001 or 01002 end up in Europe after I load them into the map. I thought it was because the first zero was truncated, so I formatted cells with 0####. However this still does not work, and the...
  17. M

    Moving Data into one Row Based on ID and First Mention

    With the below spreadsheet, I am attempting to have one row per unique identifier. You can see in the 8 empty columns to the right, I need to show if and when each person first attended each of the 4 steps as shown in the Attribute column. However, since some people may have attended one of the...
  18. A

    DAX Max Month Measure

    I am new to this DAX language and I am sure the solution isa very simple one, but I would appreciate some help.<o:p></o:p> <o:p> </o:p> I have created two measures. <o:p></o:p> MAX MONTH=MONTH(MAX('MONTHLYSALES 002'[Date])) 2016 ADJ NET SALES-YTD= CALCULATE(SUM([ADJUSTED NET SALES])...
  19. Q

    How to back into a weighted average?

    <tbody> I need help calculating a weighted average rate for a specific value. I know value 226 has a weighted average of 0.33920. How would I calculate this, given the criteria below? Thanks in advance for your help, it is much appreciated. <colgroup><col width="77" style="width: 58pt...
  20. L

    Vba beginner question

    To dear all. In my vba task, I meet one question like the following. Hope someone can do me a favor. <tbody> <colgroup><col></colgroup><tbody> Random uniform 1 2 3 4 5 6 7 8 9 10 11 12 </tbody> <colgroup><col></colgroup><tbody> 0,964274899 0,038850448...

Some videos you may like

This Week's Hot Topics