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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
unnijoy
Post Partisan
Post Partisan

current month and Previous month

In our project we are using the month is diffrent way. Below is the sample. Here am facing issue for using previous month function. How can i fix this. For example the data is till up to P4. so how can i get previous month data. Because the total sales for previous month data will total sales from Feb 20 - March 27. How can i get this.

 

 

Month.png

2 REPLIES 2
v-luwang-msft
Community Support
Community Support

Hi @unnijoy ,

previous month data will total sales from Feb 20 - March 27,but  from data you provided ,last month is Feb 28 - March 27.

And could you pls share detail sample data ,and output result you expect.

 

 

Best Regards

Lucien

Fowmy
Super User
Super User

@unnijoy 

Can you share some sample data with the desired output to have a clear understanding of your question? Mention whether you want a calculated column or measure
You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.


Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors