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.
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.
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
@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.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |