Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Need help in loading only fiscal year data based on month and year

Hi Everyone, I have a table in which I have only Month_Year 01-2022, 02-2023 so on. My objective is to load data only fpr latest fiscal year that is 04-2022 to 03-2023. Based on month year is it possible to bring the fiscal years and limit the data as well using parameters or some other functionality. Any help will be appreciated. Thanks in advance.

 

 

Capture.JPG

Status: Investigating

Hi @noelsamuel30 ,

 

The following two threads describe the operation steps in detail.

How to Parameterize Data Sources in Power BI | phData

Dynamic Filtering Using Parameters in Power BI / Blogs / Perficient

 

 

Best regards.
Community Support Team_ Caitlyn

Comments
v-xiaoyan-msft
Community Support
Status changed to: Investigating

Hi @noelsamuel30 ,

 

The following two threads describe the operation steps in detail.

How to Parameterize Data Sources in Power BI | phData

Dynamic Filtering Using Parameters in Power BI / Blogs / Perficient

 

 

Best regards.
Community Support Team_ Caitlyn