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.
I'm a newbie, so I'll apologize ahead of time if the answer is obvious.
We have a Power BI that pulls SQL data with items name, expected revenue & date of delivery.
Created a visual, that uses the date of delivery and summarization of expected Revenue by Month
We would like to show Expected Revenue by month (based upon how many working days are in a month), to give us revenue per day like the following
I assume that I should create a manually entered table that has the days per month and somehow associate it with the SQL Queries "Date of Delivery" Month value, once I have that relationship, I can then create a new column which divides revenue by days of the month number derived by the association????
@surfingjoe, I recommend creating a date table that contains a Working Day column (Y/N flag). This will allow you to calculate the number of working days in each month.
Proud to be a Super User!
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |