1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Deriving monthly numbers from YTD file

Discussion in 'Power Pivot, Power Map etc' started by nileshpca, Nov 14, 2017.

  1. nileshpca

    nileshpca New Member

    Messages:
    1
    I have a table with monthly trial balances for every month end dates and want to make derive monthly MIS. Financial year ends 31st March

    Tried with CALCULATE, FILTER but no success.

    Uploaded file with dummy data and report required.

    Please help.

    Thanks...

    Attached Files:

  2. Chihiro

    Chihiro Excel Ninja

    Messages:
    3,805
    Why is value for 201406 subtracted from 201503? There's certainly more than a month between these dates.

    Or does your actual data have each month's data?

    Also, in order for many of time intelligence DAX formula to work, you need full date cycle for each year from 1/1 to 12/31.

    Edit: For an example read link about how PREVIOUSMONTH works.
    http://community.powerbi.com/t5/Desktop/PREVIOUSMONTH/m-p/29765
    Thomas Kuriakose likes this.

Share This Page