Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Select individual CSV data source files based on the date

Let me give you a bit of background, as it is now driving me around the bend. I am trying to report on Paper Cut printer logs, and it outputs three logs. A daily log, a monthly log and a from the ...
Need Help
  • dax's avatar
    dax
    6 years ago

    Hi Anonymous , 

    I don't know how you store the data, each day per csv file or all data in a csv file? If it is previous one and you want to see current day of log, you could try to use date as csv file name , and use parameter in M code to change file name dynamically. If it is later one and csv file have date column, you could use date parameter to filter date range and load data in model. You could refer to power-bi-introduction-working-with-parameters-in-power-bi-desktop-part-4  for details.

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

dax's avatar
dax
Community Support
6 years ago

Hi Anonymous , 

I don't know how you store the data, each day per csv file or all data in a csv file? If it is previous one and you want to see current day of log, you could try to use date as csv file name , and use parameter in M code to change file name dynamically. If it is later one and csv file have date column, you could use date parameter to filter date range and load data in model. You could refer to power-bi-introduction-working-with-parameters-in-power-bi-desktop-part-4  for details.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.