Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi
I have a Annual Overhead for the company, and ideally without generating additional tables, I would like to convert that Annual Overhead down to a Monthly / Weekly / Hourly Total; for this to be augmented with existing Sales Data, which has the augmented data of Hour_From_To already appended to each transactional line (IE -> 09-10; 10-11, 11-12, 12-13.....).
Ideally I can do this dynamically in DAX, and not have to create 365Days x 24 Hours Table for each year, for each Company; For Each Overhead Type, as I have multiple Companies and Overhead Types to do this for, and the numbers will very quickly stack up.
Any input will be very much appreciated!
You may take a look at the post below.
User | Count |
---|---|
131 | |
108 | |
101 | |
67 | |
64 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |