Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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.
@lavdeep You can add month name column both in Dax or power query editor.
For Pbi Desktop (Dax) you need to add one column and use this
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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
111 | |
107 | |
106 | |
90 | |
61 |
User | Count |
---|---|
165 | |
136 | |
134 | |
97 | |
86 |