Forum Discussion
Helper IIIncremental load-odbc custom query-rolling two financial year
Hi rob_vander2 ,
I apologize for sharing the incorrect link earlier.
Please use the link below it walks you through the steps to set up incremental refresh and choose the archival period that works best for your needs: Configure incremental refresh for Power BI semantic models - Power BI | Microsoft Learn
Also, look at the attached screenshot. It shows where and how you can set the archival period based on your requirements.
Hope this helps. Please reach out for further assistance.
If this post helps, then please consider to Accept as the solution to help the other members find it more quickly and a kudos would be appreciated.
Thank you for your patience and understanding.
Hi rob_vander2 ,
Please use the document provided below as a reference and try implementing incremental refresh: Incremental refresh for semantic models in Power BI - Power BI | Microsoft Learn
Thank you.
Helper IIAnonymous I am not able to find the scenario in this link I am working on.
Hi rob_vander2 ,
I apologize for sharing the incorrect link earlier.
Please use the link below it walks you through the steps to set up incremental refresh and choose the archival period that works best for your needs: Configure incremental refresh for Power BI semantic models - Power BI | Microsoft Learn
Also, look at the attached screenshot. It shows where and how you can set the archival period based on your requirements.
Hope this helps. Please reach out for further assistance.
If this post helps, then please consider to Accept as the solution to help the other members find it more quickly and a kudos would be appreciated.
Thank you for your patience and understanding.
KhushboobaraiHelper V
Hii, can you help me with the below query of year
Can you tell me How to make a year measure which shoudl have condition like even if the data doest not have value for all month like all 12 month then also the whole 12 month ka value should show by taking some of the month from previous year to complete the 12 month sereies with cureent year.
FOR eg: for year 2025 my data has the value only for three month like jan,feb and march. and year 2024 have all jan to dec okayso in my matric visual i want the result to shown as
apr-24 may -24, jun-24, july-24 ......nov-24, dec-24, jan-25, feb-25,mar-25
I hope from the above kidn of example you get my question, so it should be like that much dynmich thta if 2025 get any new month added to data then accoridng it should show from prevoiud year till current year by considering of 12 month series