Forum Discussion

gco's avatar
gco
Icon for Resolver II rankResolver II
7 years ago
Solved

Calendar question

Hi there,   I have a date column that shows dates for current year (01/01/2019-12/31/2019).  And i would like to create a calculated column called "IsCurrentorPastMonth?" and will have a value of Y...
Need Help
  • Nathaniel_C's avatar
    Nathaniel_C
    7 years ago

    Hi gco ,

    Here is the input form for the conditional column.


    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
    Nathaniel

     

Nathaniel_C's avatar
Nathaniel_C
Icon for Community Champion rankCommunity Champion
7 years ago

Just tried it with 10/31 and it works.  Good point.

Nathaniel_C's avatar
Nathaniel_C
Icon for Community Champion rankCommunity Champion
7 years ago

Hi gco ,

Here is the input form for the conditional column.


Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

 

  • gco's avatar
    gco
    Icon for Resolver II rankResolver II
    7 years ago

    Nathaniel_C 

     

    nevermind i just saw your other response.  I am trying it now.

  • gco's avatar
    gco
    Icon for Resolver II rankResolver II
    7 years ago

    Hi Nathaniel_C ,

     

    You are a super hero!!! thank you again

    Glen

    • Nathaniel_C's avatar
      Nathaniel_C
      Icon for Community Champion rankCommunity Champion
      7 years ago

      gco ,

      You are welcome! MattAllington  book Supercharge Power BI is a great place to start. And remember, I get paid by Kudos...the thumbs up.

      Cheers,

      • gco's avatar
        gco
        Icon for Resolver II rankResolver II
        7 years ago

        Nathaniel_C 

        it looks like i can't on the past posts.  I just did it on this new one.  Thanks again!