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
Msta's avatar
Msta
Icon for Helper I rankHelper I
5 years ago

Create a new table and add relationship;

Months = SELECTCOLUMNS(GENERATESERIES(1,12,1),"MonthNo", [Value])




Add this new column to matrix.

Then change properties of  measure in visualisation "Show Item with no data" or change your measures to display 0 instedof BLANK()

 

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

    Hi Msta,

     

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