Forum Discussion
Subtract Single Measure Used in Two Columns in Matrix
Greetings, I'm struggling to get my head around how to substract a measure that is used twice in my matrix. Below is the table: Forecast Type Week Ahead Two Weeks Ahead Node Type Accura...
I got around it by doing two CALCULATES, filtering by the Forecast Type and then subtracting one from the other, not 100% what I was after but filled a gap 🙂
amitchandak
Super User
Super UserAnonymous , do you week in date or week format ?
Can you share sample data and sample output in table format?
Refer Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123
https://www.youtube.com/watch?v=pnAesWxYgJ8