Forum Discussion

siem's avatar
siem
New Member
3 years ago
Solved

Create a table in power bi

Hello, i want create a table date calendrier in power bi. 

I did in dax : 

Calendrier =
ADDCOLUMNS(
    CALENDAR(DATE(2019,1,1), DATE(2021,12,31)),
    "Year", YEAR([Date]),
    "Quarter", CONCATENATE("Q",FORMAT(CEILING(MONTH([Date])/3,1),"0#")),
    "Month", FORMAT([Date],"MMM"),
    "Month Number", MONTH([Date]),
    "Day of Month", DAY([Date]),
    "Day of Week", FORMAT([Date],"dddd"),
    "Week Number", WEEKNUM([Date]),
    "Date2", FORMAT([Date],"MM/DD/YYYY")
)
 
It created me well all my champ like I want.
But when I open power QUERY, this doesn't appear like a table.
So I would like to know why, and how I can change that ? 
thanks in advance
  • Hello siem ,

     

    yes, it is considered as table but it also has a measure inside it, that's why you can see this measure icon on the table icon.

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

    Follow me on Linkedin

3 Replies

  • Hello siem ,

     

    So what appears in power query are tables loaded from a source or created in power query then its loaded into power bi.

     

    in your situation, you created the calendar table in power bi not in power query, thus you wont be able to see it in power query, so if you want to add a column for example to this table, then you should add in from the data view of the table not in power query.

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

    Follow me on Linkedin

    • siem's avatar
      siem
      New Member

      In power bi, I see that : 

       

      As you can see, my table calendrier is not considered as a table

      • Idrissshatila's avatar
        Idrissshatila
        Super User

        Hello siem ,

         

        yes, it is considered as table but it also has a measure inside it, that's why you can see this measure icon on the table icon.

         

        If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

        Follow me on Linkedin