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.
Hello,
Hoping you can help, might not have done this correctly but here's where I am. I have two date columns, start and end. Shown as i.e 01 Feburary 2015.
In then needed to change the format so created two new columns with the measure of
Solved! Go to Solution.
Hi @rosscortb
It could not work when you sort the same value[Start Date and End Date] by different values[Start Date].You may use sort by 'Start Date Mon' as below green part.
Hi @rosscortb
It could not work when you sort the same value[Start Date and End Date] by different values[Start Date].You may use sort by 'Start Date Mon' as below green part.
Thanks for your help @v-cherch-msft , wasn't aware that you could join the columns that way. Thanks again.
Really don't get what you're asking exactly - you go on about concatenating a couple of columns together then go off on a complete tangent, can you clarify what you're actually wanting?
When you say 'Sort by Column' hopefully you know about https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column#sort-using-the-sort-by-column-butto...
and you could use the job positions[start date]
Yeah, wouldn't let me use Start Date.
Ah, fine. Error messages are usually helpful.
The message says it doesn't know how to sort because start date is not unique 'enough', that is, the same start date exists for different 'start and end date' values.
So you need to find a way of making it unique, maybe add a calculated column (number) to sort by, constructed from the 'start and end date' field like yyyymmdd from start date and append yyyymm from end date. Just an idea, i haven't tested it.
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 |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |