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.
So I'm not very good with M code in the Query Editor. I have a column that has the end of month date. I want to use the month and year from this column to create another column but make the day the 15th instead.
My attempt was below but it doesn't work:
Date.Month([End of Source Month]) & "/15/" & Date.Year([End of Source Month])
Solved! Go to Solution.
Perhaps:
= Table.AddColumn(#"Changed Type", "Custom", each Date.FromText(Text.From(Date.Month([Date])) & "/15/" & Text.From(Date.Year([Date]))))
Perhaps:
= Table.AddColumn(#"Changed Type", "Custom", each Date.FromText(Text.From(Date.Month([Date])) & "/15/" & Text.From(Date.Year([Date]))))
Hi @Anonymous,
Try this formula ( #duration function )
[End of Source Month]+#duration (14,0,0,0)
Hope it helps...
Ninter
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 | |
77 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |