Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

October 28 & 29: Experts share their secrets on how to pass the Fabric Analytics Engineer certification exam—live. Learn more

Reply
J0nny101
New Member

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  

1 ACCEPTED SOLUTION
tackytechtom
Super User
Super User

Hi @J0nny101 ,

 

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

 

tomfox_0-1649278527542.png

 

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

 

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

 



Did I answer your question➡️ Please, mark my post as a solution ✔️

Also happily accepting Kudos 🙂

Feel free to connect with me on LinkedIn! linkedIn

#proudtobeasuperuser 

View solution in original post

4 REPLIES 4
J0nny101
New Member

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 

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:

tomfox_0-1649436824595.png

 

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/

 



Did I answer your question➡️ Please, mark my post as a solution ✔️

Also happily accepting Kudos 🙂

Feel free to connect with me on LinkedIn! linkedIn

#proudtobeasuperuser 

Perfect thats got it! 

 

Thank you so much!

tackytechtom
Super User
Super User

Hi @J0nny101 ,

 

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

 

tomfox_0-1649278527542.png

 

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

 

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

 



Did I answer your question➡️ Please, mark my post as a solution ✔️

Also happily accepting Kudos 🙂

Feel free to connect with me on LinkedIn! linkedIn

#proudtobeasuperuser 

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.