Forum Discussion
multiple values was supplied for single value error
Hi All,
I couldnt get a better solution to return multiple values.
I want to return all of employee names , filter date of join as this month
New measure= CALCULATE(VALUES [emp name], MONTH(date)= MOnth(Today()))
error : multiple values supplied error.
I tried using MAX, FIRSTNONBLANK, SELECTEDVALUE = all same error.
Hi schoden ,
Do you want a visual or a table?
If you want a visual, please create a measure like below and add it to visual filter.
Measure = IF(MONTH(SELECTEDVALUE('Table'[date]))=MONTH(TODAY()),1,0)If you want a tbale, please check the formula below.
Table 2 = FILTER('Table',MONTH('Table'[date])=MONTH(TODAY()))Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
7 Replies
schoden , You have to use it like this
New measure= CALCULATE(max [emp name], MONTH(date)= MOnth(Today()))
New measure= CALCULATE(count [emp name], MONTH(date)= MOnth(Today()))
or use firstnonblank on emp name.
If you trying to filter emp name. Use this measure along with emp name in a visual, it will filter it in the visual
Hi schoden ,
Do you want a visual or a table?
If you want a visual, please create a measure like below and add it to visual filter.
Measure = IF(MONTH(SELECTEDVALUE('Table'[date]))=MONTH(TODAY()),1,0)If you want a tbale, please check the formula below.
Table 2 = FILTER('Table',MONTH('Table'[date])=MONTH(TODAY()))Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous Thanks for your effort:D it solved.
I have another problem : I want to customise week number from any start date for example;
Date_start = 29/09/2019, 30/09/2019, 5/10/2019 and so on
WeekNum=1,1 ,2 and so on
Please share me your idea . Thanks
