Forum Discussion

schoden's avatar
schoden
Post Partisan
6 years ago
Solved

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], MON...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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's avatar
Anonymous
Not applicable
6 years ago

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.

 

schoden's avatar
schoden
Post Partisan
6 years ago

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