Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Column Management

Good afternoon, I need to show in a table three columns with the total of the sales depending on the month and year you choose: For example, if I chose the year 2020 and February should show: De...
sturlaws's avatar
sturlaws
Resident Rockstar
6 years ago

Hi Anonymous 

 

in order to get achieve this behaviour, I think you need to create a new stand-alone date-table(make sure the new table is not connected to any of the other tables), and create a measure like this:

Filter Measure = 
VAR _selectedMonth =
    IF (
        HASONEVALUE ( 'Year-Month'[YearMonthNum] );
        CALCULATE ( SELECTEDVALUE ( 'Year-Month'[YearMonthNum] ) );
        ( year(TODAY ()) - 2010 ) * 12
            + MONTH ( TODAY () )
    )
RETURN
    IF (
        COUNTROWS (
            FILTER (
                dimDate;
                dimDate[YearMonthNum] >= _selectedMonth - 2
                    && dimDate[YearMonthNum] <= _selectedMonth
            )
        ) > 0;
        1;
        0
    )
 

Use this measure in the filter pane, and set it to filter on equal to 1.

 

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.