Results 1 to 2 of 2

Thread: Help please - Accruals flag M power query or DAX

  1. #1
    Neophyte I Like PI's Avatar
    Join Date
    Jan 2019
    Posts
    2
    Articles
    0
    Excel Version
    2016

    Help please - Accruals flag M power query or DAX



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I am importing a table and would like to calculate a flag per row... whenever I think Calculated column I tend to want to do the lift as part of the import but regardless I am not sure I how to build this flag in either case.
    We have different accrual rules depending on the period spanned ie we have monthly, quarterly, and Annual rules.... actually depending upon the spread a single row might span more than 1 month. I have just decided I want 3 columns. The monthly column is simple enough, if the if Date.EndOfMonth([InvoiceDate])<[GLDate] then "M" else "". Easy peasy... but quarters and annual is a bit tougher. How would I test if the date range between InvoiceDate and GLDate within the row contains quarter ends. (added wrinkle our YE is Oct 31st)
    Thoughts?

  2. #2
    Neophyte I Like PI's Avatar
    Join Date
    Jan 2019
    Posts
    2
    Articles
    0
    Excel Version
    2016
    maybe this is better in DAX through my Calendar table....

Tags for this Thread

Posting Permissions

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