Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi,
I'm trying to calculate average daily sales base on sample table above. For now if I calculate using measure, it will calculate only the total day of item sold and not the total month to date. As example, "IK YELLOW COPIER PAPER A4 450S 70G" only have 6 days of sales instead of total of 7 days. The measure calculate average for 6 days and not 7 days.
below is the ADS formula that I use currently.
@shahidalaila23 , seem fine at high level,
Try like
qty ADS = AVERAGEX(Summarize(MASTERCALENDAR,MASTERCALENDAR[itemcode], MASTERCALENDAR[DATE],"_1",[qty total]), [_1])
Can you share sample data and sample output in table format?
Hi yes,
Main data table *this my data table
and I have a master calender table
I have try the measure but it still show same result
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
79 | |
63 | |
52 | |
47 |
User | Count |
---|---|
212 | |
89 | |
76 | |
66 | |
60 |