Results 1 to 1 of 1

Trying to make simple calculations in Power Pivot

Threaded View

  1. #1
    Registered User
    Join Date
    12-08-2007
    Posts
    32

    Trying to make simple calculations in Power Pivot

    Hi Folks,

    Rank Newbie with Power Pivot and Dax.

    I have to have 400,000 baht in my Krungsi Bank Account by October 1. I created a very simple table that showed where I was in January and fed that to the Data Model. The most important number i need is how much I need to put into that account each month - for all intents a running balance. Could someone have a look? If things arent described well enough, please let me know.

    The sheets of interest in Power Pivot are "dkrung", and in the regular workbook sheet "Krungsi Bank Amounts"

    I know I have a lot to learn, and i dont expect people to spoon feed me the answer, but some general guidance like "go study calculated fileds and measures and relationships" is fine.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] 2 fields checker- Request for alternative option in Power Query or Power Pivot
    By Shareez Saleem in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-15-2020, 08:36 AM
  2. Replies: 3
    Last Post: 08-10-2020, 11:38 AM
  3. Sub-Forum for Excel Power Tools (Power Query, Power Pivot & Power BI)
    By chullan88 in forum Suggestions for Improvement
    Replies: 10
    Last Post: 06-28-2018, 02:25 PM
  4. [SOLVED] Use grand totals from pivot tables to make calculations
    By Aragon-01 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-19-2017, 09:22 AM
  5. Simple SQL Query in Power Pivot
    By zicitron in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-30-2014, 12:42 PM
  6. Help make my Excel formula work in Power Pivot / Dax language
    By Paul Reins in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-10-2013, 03:27 PM
  7. make Pivot Table Calculations
    By Carrie in forum Excel General
    Replies: 0
    Last Post: 08-18-2006, 02:35 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1