Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Date

Hi all!   Relativly new to the BI world so please bear with me.  We are looking at our systems refresh rates and need to be able to show a percentage of the first 8 days of a month for the las...
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hey Tom,

 

That worked perfectly thank you!

 

My next question is, i want to put this into a line graph and want to make it so that it will show the first 8 days of say April now but next month i would want it to automatically update to May is that possible? 

 

Thansk,

Jon 

  • tackytechtom's avatar
    tackytechtom
    Icon for Most Valuable Professional rankMost Valuable Professional
    4 years ago

    Hi Anonymous ,

     

    It should be possible to build this into your measure. You could create a variable where you fetch the current month like VAR _currentMonth = MONTH ( TODAY() ). After you could use it to filter your measure with that VAR. 

     

    Sometimes it is easier though to use the filter pane on the visual directly:

     

    This one would also change each month. 

    If either of the two solutions helped you, you can mark them as solution so it will be easier for others to find it 🙂


    /Tom
    https://www.tackytech.blog/
    https://www.instagram.com/tackytechtom/

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Perfect thats got it! 

       

      Thank you so much!