Date

[J0nny101]

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  

[J0nny101]

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]

Hi @J0nny101 ,

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/

[J0nny101]

Perfect thats got it! 

Thank you so much!

[tackytechtom · Accepted solution]

Hi @J0nny101 ,

The DAY() function returns the day for each month:

Would it solve your issue by using a filter like "DAY ( Date[Date] ) <= 8"? 🙂

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