The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I have several measures which count rows where critieria are met. This is shown in the report as
It would be really helpful to store the current value of the measures in a new table that I could then use to illustrate the trend over time.
E.g.
The Power BI file will be opened every day, and will have the refresh button clicked often.
I was wondering if it's possible that when the refresh button is clicked, as part of the refresh activity the table shown above has 'todays' numbers added to it.
Or, if there is a better way of taking the values from the measures and establishing the trend over time.
The data source used for Power BI shows the current days 'open' items only so I can't retreive the history from the source file.
I could change the process for creation of the source file to include the date in the source excel filename, load all files in the directory, load all the spreadsheets into a table with a date, then use the date from the filename to build the history over time.
I just wondered if there is a different, more efficient approach without having to manually rename 'todays new file' to include a date.
Hope the question makes sense - if it's unclear please could you let me know.
Thanks,
Richard
Solved! Go to Solution.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsRegards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThanks for clarifying Miguel and for the alternative ideas - Appreciate you taking the time to respond.
I think i'll rename 'todays' file every day and store it with the old files in a directory.
Combining these files on import will let me create the trend over time.
Cheers,
Richard
User | Count |
---|---|
79 | |
74 | |
42 | |
30 | |
28 |
User | Count |
---|---|
108 | |
96 | |
53 | |
48 | |
47 |