Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Date Range

Hi all,    My client has requested me to have a specific date range within a chart.  Can anyone show me how to create a date range as follows:  Min Date: Current Month - 2 Max Date Current Month...
Need Help
  • Mariusz's avatar
    Mariusz
    7 years ago

    Hi Anonymous 


    You can downlad this calendar table and apply the filter as below.

     

    Regards,
    Mariusz

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

Mariusz's avatar
Mariusz
Community Champion
7 years ago

Hi Anonymous 


You can downlad this calendar table and apply the filter as below.

 

Regards,
Mariusz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Mariusz Thanks for helping me with this, I am however solutioning this in a established data mdel. 

Can you please let me know how did you build the sYear field?

 

  • Mariusz's avatar
    Mariusz
    Community Champion
    7 years ago

    Hi Anonymous 

    Please download the file and see the Query Steps it should be fairly easy to understad.

    If you are struggling then please let me know.

    Regards,
    Mariusz

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Mariusz 

      I am almost there, 

      Date.Year([Date]) - nowYear is the custom column sYear

      However how do I get the variable nowYear? 

       

      Thanks 

      • Mariusz's avatar
        Mariusz
        Community Champion
        7 years ago

        Hi Anonymous 

        This will be 
        nowYear = Date.Year(nowDate)
        nowDate = Date.From(nowDateTime)
        nowDateTime = DateTime.LocalNow()

        Hope this helps.

        Mariusz