The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
HI,
i have colunm where date format "DD/MM/YYYY" i want to extract only month name like this "MMM" formate "Jan"
Solved! Go to Solution.
Proud to be a PBI Community Champion
Thanks for quick response
Month column showing in field list when in enter query editor column not show ??
@lavdeep Calculated columns and Tables that are created under Data Pane can't be visible/accessible under Power Query Editor. In that case, add a new field in Power Query Editor to extract the Month as below using "Custom Column" under Add Column tab.
= Table.AddColumn(#"Changed Type", "NewFieldNameMMM", each DateTime.ToText([DateField], "MMM"), type text)
Proud to be a PBI Community Champion
so if my date is 24/6/2019 and I would like to get a separate column with the month name fro all the dates.
so i should use the below., rite but in this case I am getting error for the word Format sazing its mispellt.
Format([DateField],”MMM”)
Hi,
Yours is a calculated column formula (not a M Language formula). I think you are trying to write that formula in the Query Editor - do not write it there.
Hi, I have just solved it as follows:
Date.ToText([YourColumnWithDate], "MMM"), type text)
Date.ToText([YourColumnWithDate], "MMMMM"), type text)
Hope it helps!
Jaime
Hello All,
I'm really new on this. I'm trying to get the month name from two columns using an if function.
I need for example if column "Delivery Type" has "Miami_Xdock" it should bring the month name from column "Leg2 Order Received", if not it should bring month name from Column "Leg1 Actual Delivery Date"
I was trying the two below:
IF(Deliveries_db[Delivery Type]="Miami_Xdock",MONTH([Leg2 Order Received],[Leg1 Actual Delivery Date])) This one didn't work
Hello All,
i just solved it myself. I used the below and works perfect
Proud to be a PBI Community Champion
its not working for me. I am still getting dates
Proud to be a PBI Community Champion
Hello,
I am new to Power BI and learning. In the screenshot u will find the 3 tables in which the center one is the bridge table.
Now I want to find the which and the number of jobs(jobname) under which assignee group got finished, cancelled (Status Attribute).
so if my date is 24/6/2019 and I would like to get a separate column with the month name fro all the dates.
so i should use the below., rite but in this case I am getting error for the word Format sazing its mispellt.
Format([DateField],”MMM”)
Hi,
Yours is a calculated column formula (not a M Language formula). I think you are trying to write that formula in the Query Editor - do not write it there.
Thanks for quick response
Month column showing in field list when in enter query editor column not show ??
@lavdeep Calculated columns and Tables that are created under Data Pane can't be visible/accessible under Power Query Editor. In that case, add a new field in Power Query Editor to extract the Month as below using "Custom Column" under Add Column tab.
= Table.AddColumn(#"Changed Type", "NewFieldNameMMM", each DateTime.ToText([DateField], "MMM"), type text)
Proud to be a PBI Community Champion
Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.
User | Count |
---|---|
158 | |
106 | |
96 | |
83 | |
75 |
User | Count |
---|---|
154 | |
137 | |
131 | |
81 | |
62 |