Forum Discussion

Jerush's avatar
Jerush
Icon for Helper I rankHelper I
5 years ago

How to create dummy columns in numeric order based on a date difference

Hi All, I have created a report using the matrix visual. The column is a date difference in month. 1, 2, 3.... Row is a date value. There are some months "missing" purely due to what the data is, h...
Need Help
Tips and Tricks
Tutorial Requests
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Jerush , Create a table with values , using generateseries

 

month= generateseries(1,12,1)

 

Join this with the column in your table.

 

Create a measure with +0 and use

count(Table[column]) +0

Jerush's avatar
Jerush
Icon for Helper I rankHelper I
5 years ago

Hi amitchandak 

 

Thank you for the speedy reply. I will give this a go. 

Much Appreciated.