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 last 12 months.

 

I am comfortable making the percentage calculation my issue is creating the filter that is required to only show the first 8 days of the month and then apply this for twelve months data?


any help would be greatly appreciated!

 

thanks,

jon  

4 Replies

  • 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
      Most 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!