Forum Discussion

unnijoy's avatar
unnijoy
Icon for Post Prodigy rankPost Prodigy
5 years ago

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.

 

 

Need Help

2 Replies

  • Fowmy's avatar
    Fowmy
    Icon for Super User rankSuper User
    5 years ago

    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.


  • v-luwang-msft's avatar
    v-luwang-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    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