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.
I have created a new column with this:
Solved! Go to Solution.
Hi @Lunge_PTP ,
You can also use FORMAT for this purpose:
FORMAT('Calendar'[Indbetalingsdato],"YYYY-MM")
Hi @Lunge_PTP ,
You can also use FORMAT for this purpose:
FORMAT('Calendar'[Indbetalingsdato],"YYYY-MM")
Generally I create the Calendar using Power Query. Here you can add a column like this:
Column Name: "YearMonthNo"
Expression
= Text.Combine(
{Date.ToText([Indbetalingsdato], "yyyy"), "-", Date.ToText([Indbetalingsdato], "MM")}))
Go to data view, select your new column, in column tools choose sort by (Date).
Hi @Lunge_PTP
Instead you can duplicate your date column and change its date format directly from ribbon as shown in below screenshot. Since the way you following to create a column actually its converting that column as text and its causing issue while sorting.
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
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 |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
42 | |
32 | |
30 | |
18 | |
18 |