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...
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!