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
I have a table with the days but it doesn;t show the month. How can I create a column that shows the Month & day?
Solved! Go to Solution.
pls try this
Month = IFERROR (FORMAT( DATE(2023,8, VALUE ( 'CE Lookup 2'[Day] )),"MMMM"), BLANK ( ) )
hello @Sonyat810 ,
can you show me what type of date you have ?
if you have something like 1/1/2023 for example, to have the month in a seperate column
calculated column = format ('Tablename' [datecolumn], "mmmm")
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote for my Community Mobile App Idea 💡
Proud to be a Super User! | |
This all I have as far as day, but no month. It won't let me change it to date format, so I will have to create something.
Hello @Sonyat810 ,
but how would you know this day falls under which month ? this won't work like that.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote for my Community Mobile App Idea 💡
Proud to be a Super User! | |
I want this to say "August". How do I write that? This is what I have:
pls try this
Month = IFERROR (FORMAT( DATE(2023,8, VALUE ( 'CE Lookup 2'[Day] )),"MMMM"), BLANK ( ) )
All of the days are for August.
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 | |
105 | |
105 | |
88 | |
61 |
User | Count |
---|---|
165 | |
133 | |
132 | |
95 | |
86 |