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.
Hello!
I've 2 tables in PBI model:
1) Granular daily sales values (by products, customers, etc.) with missing dates in between (sales don't happen every day)
2) A list of dates with 3 columns:
I need a graph with 2 lines:
1. Sales, MTD
2. Linear forecast for sales based on this formula: ( Sales, MTD / Month-to-date number of working days for that date
) * Total number of working days for that month
This should preferably work for quarter and year.
Would appreciate any help.
Thank you in advance.
You should be able to use my Quick Measure here for Net Work Days:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Net-Work-Days/m-p/367362
Hello Greg,
unfortunatly, the challange is not in calculating the number of working days.
Otherwise is would work, yes. 😃
OK, please post sample data to recreate the situation. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
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 |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |