Forum Discussion

abdalla's avatar
abdalla
Icon for Helper I rankHelper I
4 years ago
Solved

a table of multiple values was supplied where a single value was expected

Hello,

I am using the generate series function in power BI and this is my equation 

and this is what happens if anyone can advice on how to resolve this simple issue it would be great also tried this generate series function in more than 1 table and still gives the same result so any solutions to this?

 

Thank you 

much appreciated

 

 

  • I think You need to create new table using GENERATESERIES function insted off calcualtion or measure 

     

    I have tested with created table it is working fine 

     

     screenshot for reference 

     

     

2 Replies

  • I think You need to create new table using GENERATESERIES function insted off calcualtion or measure 

     

    I have tested with created table it is working fine 

     

     screenshot for reference 

     

     

    • abdalla's avatar
      abdalla
      Icon for Helper I rankHelper I

      Hello,

      Thank you very much i tried what you suggested and it is working perfectly fine

      Appreciate the effort.