Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi everyone,
I have the below formula to calculate 1st Month's sales.
Hi,
Create a Calendar Table with calculated column formulas for Year, Month name and Month number. Sort the Month name column by the Month number. Create a relationship (Many to One and Single) from the Date column of the Data Table to the Date column of the Calendar Table. Write these measures
Total = sum('Total-Combined'[Amount])
Sale in first month = calculate([Total],datesbetween(Calendar[Date],min(Data[Date]),eomonth(min(Data[Date]),0)))
Hope this helps.
Thankyou Ashish, what if I wanted the 2nd month's sales and the 3rd month's sales?
You are welcome. Share data in a format that can be pasted in an MS Excel file and show the expected result.
User | Count |
---|---|
84 | |
71 | |
71 | |
68 | |
55 |
User | Count |
---|---|
94 | |
92 | |
91 | |
77 | |
70 |