Forum Discussion
Tabular Editor: Non-Standard Calendar time comparisons/Conditional calculation with filters
Hi All, I am looking to transition from creating redundant time comparison measures (that require a lot of copy and pasting for measure creation) to utilizing tabular editor. A couple of ca...
The goal would be being able to build a table like this without creating a bunch of separate measure. I have measure built for the base data, but not for comparisons:
| Current Week | Last Week | L 13 Wks | MTD | QTD | YTD | Delta vs LW | Delta VS LY | |
| Consumption | sum | |||||||
| Avg Inventory On hand | average | |||||||
| Average instock | sum/sum | |||||||
| Average Velocity | sum/average | |||||||
| Average Time Supply | sum/average |