Forum Replies Created

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • February 16, 2018 at 7:31 pm in reply to: date measure as a filter in Calculate function #9238

    zeitss
    Participant
    • Started: 1
    • Replies: 3
    • Total: 4

    YES!  this gives me the result expected.  wow, so much to simply get the most current date from data source and use it in a formula.  🙂

    February 15, 2018 at 7:06 pm in reply to: date measure as a filter in Calculate function #9228

    zeitss
    Participant
    • Started: 1
    • Replies: 3
    • Total: 4

    sorry tomallan, i did not give you the whole story.  i’m actually trying to pull the current date from the data source, and not hard code it.  i hard coded the date above to explain my issue, not realizing i would still have an issue.  your solution works for what i gave, but consider the following formula:

    Current Commission:=
    CALCULATE(
    [pd Commission],
    FILTER(ALL(dsComm),dsComm[Commission Month]=[Curr Comm Month])
    )

    this formula works when:
    Curr Comm Month:=date(2018,1,1)  i get just January’s results

    this formula doesn’t work when:
    Curr Comm Month:=max(dsComm[Commission Month])  i get the total result of dataset instead of result for just January

    but both ways appear to produce the exact same output, a January date in date time format.  can i not pull the date from the data source and use it in my formulas?

    thanks and sorry for not giving the complete problem.

    February 15, 2018 at 5:28 pm in reply to: date measure as a filter in Calculate function #9227

    zeitss
    Participant
    • Started: 1
    • Replies: 3
    • Total: 4

    that worked perfectly!  thank you tomallan and thanks for the explanation.

  • Author
    Posts
Viewing 3 posts - 1 through 3 (of 3 total)