Forum

Hi Valeria, A separate date table allows you to use those fields in DAX measures/formulas, whereas with an implicit date hierarchy you don't have t...

Hi Paul, Nothing attached. You need to click the yellow 'start upload' button to complete the upload process. Mynda

Hi Anne, When I've tried this in the past I've come up blank. There are paid services, but nothing I could find for free. You don't need long. a...

In my opinion the PivotTable is the correct approach because now you have your data in the correct tabular format you can do much more than just calcu...

Hi Paul, You can attach it here. Click the 'Attachment' button at the bottom of the reply window > choose your file > click the yellow 'Start...

Hi Paul, When you say you reformat in Power Pivot, what are you doing to reformat exactly? Do you have a sample of the dates that are misbehavin...

Hi Bax, This isn't a job for Power Query. In Power Query you should unpivot your data so it's in a tabular layout. In other words you shouldn't hav...

Sounds like a bug, Harry. Can you please share a sample file so I can reproduce the issue and report to Microsoft if it is a bug. Thanks, Mynda

Hi Karen, My assumption is that you will have one Master file and many User Form files. These files will get added to and updated daily/weekly, as ...

Hi Bax, You could add a helper column to your source data that numbers the consultants in each time sheet. You can then use this field in your colu...

Hi Karen, Thanks for putting some data in the files and clarifying the points. Yes, Power Query can validate character length. Not sure what you me...

Hi Dave, I don't know a way to sort columns from an external list either, but you could create the line of M code outside of Power Query and copy i...

Hi Bax, I agree with Anders. Your data is currently in the correct tabular format. From here you can get your summary with a PivotTable. See attach...

Hi Fernando, I've not tried as I don't have any .dbf files, but this thread offers a solution: Note: it's in Power BI, but Power BI uses the sa...

Hi Crystal, This is a job for the dates table, in that you should have this as a column in your date table. You can either add this column in the m...