Order Date function not on display in View Table (Power BI)

[Cke]

Hi there,

I am looking for some help please 🙂

I am trying to use the function Order Date in Power BI (View Table mode). However it does not appear after creating a new column. I am attaching a photo (from a Youtube video) of what I am trying to get vs a photo of what my View Table mode really displays.

Image 1. What I need to get

Image 2. What my View Table displays

In my power BI I cannot see all the functions displayed in the Youtube video despite I am texting the function similarly.

What I can do to get the functions on display in the video?

Note: the link for the Youtube video I am trying to imitate is: https://www.youtube.com/watch?v=L4z-sZvUDFU

Thank you in advance  🙂

[Natarajan_M · Accepted solution]

Hi @Cke ,

Month is the function order date is the column in the table used in the video .

to get the month number you need to use the 

Month = month(financials[Date])

make sure the Date is in the correct date datatype 

https://learn.microsoft.com/en-us/dax/month-function-dax

Thanks 

If this response was helpful in any way, I’d gladly accept a kudo.
Please mark it as the correct solution. It helps other community members find their way faster.

[Natarajan_M · Accepted solution]

Hi @Cke ,

Month is the function order date is the column in the table used in the video .

to get the month number you need to use the 

Month = month(financials[Date])

make sure the Date is in the correct date datatype 

https://learn.microsoft.com/en-us/dax/month-function-dax

Thanks 

If this response was helpful in any way, I’d gladly accept a kudo.
Please mark it as the correct solution. It helps other community members find their way faster.

[Cke]

Thank you so much @Natarajan_M :).

I have another question related, please: 

I am using a button slicer to filter or control the bar chart you can see in the picture. However, the date format includes the full date (day/month/year). There is any method for the name of the month to appear instead of the full date, just as in the bar graph?

Thank you so much in advance

[Ashish_Mathur]

Hi,

Create this calculated column in the Calendar table

Month name = format(calendar[date],"mmmm")

[Cke]

Thank you,

However, in the resultant button months are not chronologically organized, so I got back to my initial question. 

[pcoley]

@Cke MonthName will be sort alphabetically by default.
To sort by number of month you should have a column in your table with the corresponding month number (MONTHNUMBER); then select the column that has the name of months (MONTHNAME) column... finally, in the ColumnTools Select "SortByColumn">[select the column that has the corresponding month numbers]

1. MonthNumber Column:

2. SortByColumn

This should be enough to enable the sort as you wanted, please go back to your viz and check if it works as expected

I hope this helps, if so please mark it as a solution, kudos are welcome.

[pcoley]

@Cke MonthName will be sort alphabetically by default.
To sort by number of month you should have a column in your table with the corresponding month number (MONTHNUMBER); then select the column that has the name of months (MONTHNAME) column... finally, in the ColumnTools Select "SortByColumn">[select the column that has the corresponding month numbers]

This should be enough to enable the sort as you wanted, please go back to your viz and check if it works as expected

I hope this helps, if so please mark it as a solution, kudos are welcome.

[Cke]

thank you so much for your answer, I cannot mark it as the solution because another person gave me the solution before. However, your answer is quite elaborated 🙂

[Natarajan_M · Accepted solution]

Hi @Cke  can you use the sort by columns option. 

Select the column thats used in the button slicer then sort by month. Number this should resolve the sorting issue 

[Cke]

thank you so much!

[MFelix]

Hi @Cke ,

The Order Date is not a function is a column on the orders table.

If you do not have that table and that column you want BE able to see the column.