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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Stifri
New Member

Periods date related to sales and date

Hi, 

 

So this is how it should look like 

Period 1 = "Changable date"

Period 2 = "changable date"

 

Tablenames "Company" "Period 1 sales" "Period 2 sales"

 

So I need to able to change the date in period 1 and then only period one sales should be changing even though they come from the same table in the beginning. 

2 REPLIES 2
v-frfei-msft
Community Support
Community Support

Hi @Stifri .

 

Kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
amitchandak
Super User
Super User

Please check this example

https://medium.com/chandakamit/power-bi-comparing-data-across-date-ranges-36be49b68613

 

There two methods. For the other method, the method link is given in the article.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.