Search:

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

Search: Search took 0.00 seconds.

  1. Re: Dynamic DAX calculation between two rows of same DAX measure (filtered rows)

    Kindly see below for the revised correct numbers:
    (Sorry, I'm unable to insert image for some weird reason, so let me attach as a hyperlink below instead)

    https://imgur.com/BmX1HAA


    The...
  2. Re: Dynamic DAX calculation between two rows of same DAX measure (filtered rows)

    You're right! I forgot to make the figures actuals after I randomized the data!!! Pardon me for overlooking the detail!!
  3. Dynamic DAX calculation between two rows of same DAX measure (filtered rows)

    Background:
    I have a measure that calculates Total sales from a master sales data that captures actual sales and forecasted sales on a monthly basis.

    Sample data:
    And a sample looks like below:...
  4. Data transformation (using Formula) in Power pivot for data source from Folder

    Background:

    I've configured a PowerQuery to automatically fetch a sales and forecast dataset that updates monthly.
    So, the dataset gets arranged based on the Source File which gets refreshed on...
  5. Select sheet based on sheet name and copy range of columns from one workbook to another

    I have 2 workbooks with various sheets in each book. I would like to copy a certain range of columns (A:J) from source to target book (same range A:J).

    Additionally, I need to copy from source...
Results 1 to 5 of 5