I have data in 2 table. 1st table has data month wise in row. And second table has data month wise in column. Is it possible to merge both the table to prepare matrix table
Watch this three videos, that will solve your problem th-cam.com/video/nu19dyCzUUU/w-d-xo.html th-cam.com/video/_lDkhgeruwU/w-d-xo.html th-cam.com/video/O79DReR6roI/w-d-xo.html
@@AnalyticswithNags I have two tables one is date table and another supplier details tables. Now I want to create a matrix visual in which 3 columns must be there first column is supplier names and second column is current month-year (May-2021) and third column name must be previous year same month(May-2020)... I created a slicer which contains year-month column values from the date table. Now in slicer if I select May-2021 then in the matrix visual i need to see the second column as May-2021 and the third column as May-2020... This is my requirement sir
@@AnalyticswithNags by using the following Dax formula Value in Matrix = IF ( SELECTEDVALUE('Table'[Date]) = DATE(YEAR(MAX('Slicer'[Date])),MONTH(MAX('Slicer'[Date]))-1,1), SUM ( 'Table'[Sales] ), BLANK () ) I am getting May-2021 and April-2021 as column names but my requirement is May-2021 and May-2020 as column names
![ILLSLICK X YOUNGOHM - We're The same [Official Video]](http://i.ytimg.com/vi/yUJNkobYR0E/mqdefault.jpg)
I have data in 2 table. 1st table has data month wise in row. And second table has data month wise in column. Is it possible to merge both the table to prepare matrix table
Watch this three videos, that will solve your problem
th-cam.com/video/nu19dyCzUUU/w-d-xo.html
th-cam.com/video/_lDkhgeruwU/w-d-xo.html
th-cam.com/video/O79DReR6roI/w-d-xo.html
Can we change a column header in matrix visual dynamically without using a slicer? Is it possible sir?
Can you elaborate. Not able to understand your exact requirements
@@AnalyticswithNags I have two tables one is date table and another supplier details tables. Now I want to create a matrix visual in which 3 columns must be there first column is supplier names and second column is current month-year (May-2021) and third column name must be previous year same month(May-2020)... I created a slicer which contains year-month column values from the date table. Now in slicer if I select May-2021 then in the matrix visual i need to see the second column as May-2021 and the third column as May-2020...
This is my requirement sir
@@AnalyticswithNags by using the following Dax formula
Value in Matrix = IF ( SELECTEDVALUE('Table'[Date]) = DATE(YEAR(MAX('Slicer'[Date])),MONTH(MAX('Slicer'[Date]))-1,1), SUM ( 'Table'[Sales] ), BLANK () )
I am getting May-2021 and April-2021 as column names but my requirement is May-2021 and May-2020 as column names