Forum Discussion
Create a new table like a matrix
Hi. I'm try to create a new calculated table like this And fill the blank spaces with "0" to represent in a line chart without blank spaces. The numbers in the matrix is a measure of ...
Hi Anonymous ,
I created a sample pbix file (see attachment), please check whether that is what you want.
1. Create a date dimension table
2. Create relationship between BD and date dimension table base on date field
3. Put Month field from date dimension table into matrix to replace month field of BD table
Best Regards
Hi Anonymous ,
I created a sample pbix file (see attachment), please check whether that is what you want.
1. Create a date dimension table
2. Create relationship between BD and date dimension table base on date field
3. Put Month field from date dimension table into matrix to replace month field of BD table
Best Regards