Forum

Hi Crystal, If you only want to keep the last character then you can use Text.End e.g.: =Text.End( [your text column], 1) Mynda

Hi Mike, It's difficult to picture the layout of your data and PivotTable, but you should be able to sort on the column you want. If you select ...

Hi Rosemary, It's impossible to say without seeing your file. Can you please upload it? Thanks, Mynda

Hi Hava, You have to convert the date serial number in A3 to text: ="YTD "&TEXT(A3,"mmm/yy") Note the space after YTD. More on conv...

Thanks for sharing, Carlos.

Hi Taylor, Great question. No! 🙂 If you don't like the automatic date grouping with the abbreviated names then you can add your own columns to...

Hi Will, Great to hear you're making progress through the courses. Your file didn't get attached, however, Power Query doesn't bring in formulas...

Hi Carlos, Yes, I advised you of the need for a dates table at the beginning. I'm not sure what you mean by 'I already get help on another site'...

Hi Will, Yes, you can use your data. You need to bring it into Power BI using the Power Query tools and transpose and format it in a tabular format...

Hi Aviram, I've never seen this done and given you've had no replies it might imply it's not possible. Here are some map chart options that you mig...

I don't think it can be done. The chart requires a date field in the Axis. You need a DAX measure that returns a table that lists the dates prior to a...

Hi Carlos, You should use the regular Slicer (not the custom one) and use the 'Between' dates option if you want to choose flexible dates that also...

Hi Tom, If you want to manually merge the data that's ok. However, I have some points of improvement for your chart that will make it quicker and c...

Hi Carlos, Thanks for sharing the files. In the attached file you'll see I've added a measure called Prior Year Measure, which uses the PARALLEL...

Hi Tom, Thanks for sharing the data. In the attached file I've used Power Query to merge the two tables and added a value for the surgery date t...