The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi All,
I have a request from Finance team for Accounts Receivable Outstanding Dashboard, to creat a possibility/ Filter to go back on the past months (at least 12 months) to show that Months Outstandings till that month.
Ex: For the Month of March 2023 my Oracle Data gives me As On Date total Outstandings always, although I should create a possibility to filter to Outstandings As On Jan 2023's month end, or Outstanding status to the As On DEC 2022.
If Outstandings are static we could have a static back dated tables saved in DB, although the data in past Outstandings also change sometime, so those backdated tables shall be refreshed.
Please help me if someone has handled a back dated data scenario, Do we need to create some alternate way of data extraction structure in Oracle.
Thank you
@VisM , check if DAX append method can help, import in append method
https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-...
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/
@amitchandak Thanks for suggestion, although Incremental will not support for Fiancial Outstandings.
I believe somehow I still have to save past instances in the DB, and may have to refresh those instances at a scheduled basis to capture any changes done on past data.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
90 | |
83 | |
64 | |
58 |
User | Count |
---|---|
244 | |
128 | |
118 | |
79 | |
78 |