Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |