Forum Discussion
Dividing two columns in matrix visualization
Hi Stachu
I will create a date table and try the solution that you suggusted.
I will come back to you once i have tried it.
Thanx again.
Gazz
can you share how the underlying table looks like? Also, do you have a separate date table in your model, or do you take it from the fact table?
Thanx for coming back to me, Stachu.
The date i am taking directly from the fact table, due to size constraints. and as you can see from the below screen shot i have added Day, month, Year Month Name and MonthY using Dax formulas.
having a separate date table will actually save space and allow you to you use built in time itnelligence, cause for each date you store Year, month etc. only once and not per each row of your dataset, see here:
https://docs.microsoft.com/en-us/power-bi/desktop-date-tables
can you also explain how the MonthY filter would work in this case?Right now I see 2 possible solutions:
1) you will need a table that would have a column that would have all possible months listed as well as the "Difference" label,
2) you can create a generic FirstMonth/Second Month Measures that would be filtered by MonthY slicers and then have 3rd measure Difference that would calculate variance between the 2Hi Stachu
I will create a date table and try the solution that you suggusted.
I will come back to you once i have tried it.
Thanx again.
Gazz