Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Get value for current month

Hi there, I have a matrix table with numerous different values for different timescales, I wanted to know how to get a value for the current month? It's more complex than I thought.  I have a s...
v-chenwuz-msft's avatar
v-chenwuz-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi Anonymous ,

 

Please change the type of the two columns in your table which you have mentioned in this measure.

Or use the VALUE or FORMAT function to convert one of the values.

 

If you need more help, please share your pbix file without sensitive data.

Best Regards

Community Support Team _ chenwu zhu

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi v-chenwuz-msft 

I've changed the [MonthNumber] column in dates table to a whole number, but now the data is just blank, here is what it looks like when I put it on my visual below: 

This is what the date table looks like below:

I did notice that when I converted the MonthNumber into a wholenumber it went from 01 to 1, 02 to 2, etc. Could this be the problem maybe? Or does that not matter?