Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Filter data by Table name

I have a table for the year 2020. I have a worksheet for each month. I created a report based out of Jan worksheet. Now I added "Feb" data to excel worksheet and when I import the file, it reads the ...
Need Help
  • VasTg's avatar
    VasTg
    6 years ago

    Anonymous 

     

    Bring them as seperate queries but append them as below.

     

     

    Before appending them, make sure you have a date column which give you the month.

     

    If it helps, mark it as a solution

    Kudos are nice too

     

     

     

     

VasTg's avatar
VasTg
Memorable Member
6 years ago

Anonymous 

 

Bring them as seperate queries but append them as below.

 

 

Before appending them, make sure you have a date column which give you the month.

 

If it helps, mark it as a solution

Kudos are nice too

 

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Can I add a column to table in BI and assign date value to it? 

    • VasTg's avatar
      VasTg
      Memorable Member
      6 years ago

      Anonymous 

       

      Ofcourse you can. There are tons of things we could do with Power BI.

       

      The image shows a Query Editor window. Click on Add Columns and Custom Column. You could either type in ="JAN" or some arbitrary date for each month. Click on the 2nd arrow and change the data type to Date. Do these for each sheet before you append them. 

       

       

      If it helps, mark it as a solution

      Kudos are nice too