Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |