Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Automate table to add months

Good morning everyone -  I am having the damndest time trying to automate a data set to automatically add a new month. I'm not even sure if this is possible.  Below is a screenshot of a data table I...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi  Anonymous ,

     

    Suppose your data is till August,such as below:

     

    First create a calendar table to the end of the year,then create a relationship between the 2 tables;

    Finally create a measure as below:

    Measure =
IF ( MONTH ( MAX ( 'Table 2'[Date] ) ) <= MONTH ( TODAY () ), 1, BLANK () )

    Put the measure in the filter pane and select measure is 1:

     

     And you will see:

    For each new adding month,you could use another measure to fill  in the data.

    For the related .pbix file,pls see attached.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my raeply as a solution!

v-kelly-msft's avatar
v-kelly-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi  Anonymous ,

 

Suppose your data is till August,such as below:

 

First create a calendar table to the end of the year,then create a relationship between the 2 tables;

Finally create a measure as below:

Measure =
IF ( MONTH ( MAX ( 'Table 2'[Date] ) ) <= MONTH ( TODAY () ), 1, BLANK () )

Put the measure in the filter pane and select measure is 1:

 

 And you will see:

For each new adding month,you could use another measure to fill  in the data.

For the related .pbix file,pls see attached.

 

Best Regards,
Kelly

Did I answer your question? Mark my raeply as a solution!

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank you, Kelly!