Forum Discussion
Variance in Matrix
Hi All, I'm stuck and will appreciate it if someone can help me with this. I have a matrix coming up as this: End of Week 19.2023 12.2.2023 Total Period Vol Vol Vol 1-7...
Ejykso , You can use isinscope to replace grand total/subtotal with variance measure
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
for variance
Power BI Abstract Thesis: How to use two Date/Period slicers
Day Intelligence - Last day, last non continous day
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c3243d1f9
Thanks amitchandak, However, the link is not opening anymore and I couldn't get to see how to replace this built-in subtotals with variance. I'll appreciate it if you could give an example using the table above.