How can you set up a daily data import from a text file when the text file name changes each day?
Give me a new question
Copy to clipboard
Do you explicitly define the model grain?
What is covered in the DAX Formula day?
What is covered in the Dimensional Modeling day?
Do you design the reports on paper, then work backwards to the data you'll need, go find it and reshape it?
How can I use one value to dynamically adjust a formula covering another range?
Is there a shortcut to manually fill cells?
How to Calculate the Next Common Number for All Items?
Want to have quick navigation to your tables in your workbook?
How is the event going to work?
Ready to learn more about pricing options and download the free trial?
Power BI Performance Tuning: What, Why and When?
How can I select the height in OFFSET function to select data between two dates?
Formula for Converting Quarterly Rate into Average Annual Rate?
Or do you go the other way, trying to collect and reshape the data, then build reports once you think you have what you need?
Where did they come from?
So now the data is nice and clean, but how to you unpivot it?
Interested in the other things Monkey Tools does?
Or do you do deeper like "I want transactions at a daily basis and want to break them down by customer, region and product"?
Want to kick it up a notch?
How do I match the length of the criteria range in AVERAGEIFS to the length of the height in my OFFSET function?