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 COUNTROWS and the values of the first column are a column of the Excel with diferent categories.
Can you help me please, and sorry for the english errors i'm starting with this.
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
5 Replies
Anonymous In your measure add in a way to convert the blank() to 0 like this:
Measure = COALESCE(COUNTROWS(Table),0)
Anonymous
Just add a 0 to your measure.. As in
no blanks = [your measure] + 0
or
no blanks = SUM(table[column]) + 0
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
