Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Auto select previous months

Hi guys,   I want to know if it is possible select one month, and the others selected automatically, like a MTD (I suppose). I have an alternative, using quarters checkbox, but, what i really want ...
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    Anonymous

     

    Try this:

     

    Create a table with Months (1....12) Use this as Slicer. Don't related with your data table.

     

    Create a Measure: 

     

    ValuesChart =
VAR MAXMONTH =
    VALUES ( Months[Month] )
RETURN
    IF (
        VALUES ( Table1[Month] ) <= MAXMONTH,
        CALCULATE ( SUM ( Table1[Values] ) ),
        BLANK ()
    )

    Use this measure in your chart.

     

Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

what is the message in ver Detalhes

Anonymous's avatar
Anonymous
Not applicable
9 years ago

MdxScript(Model) (6, 46) miscalculation as 'OINV AND ORION' [Values Chart] was provided a table of various values where it was expected one value

  • Vvelarde's avatar
    Vvelarde
    Community Champion
    9 years ago

    Anonymous

     

    I made a sample of this.

     

    Sample

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Vvelarde thank you,

       

      It is possible replicate your code in a card label, to show me a % ?

       

      I'm using your code unsuccessful in my card label:

       

       

      Var = 
VAR MAXMONTH =
    VALUES ( 'Calendar'[MonthNumber] )
RETURN
    IF (
        VALUES ( 'Calendar'[MonthNumber]) <= MAXMONTH;
        CALCULATE ( DIVIDE('OINV E ORIN'[Variação Current vs Previous Year tons Activos];'OINV E ORIN'[Consumo de clientes Tons Previous Year];0) );
        BLANK ()
    )

       

       

      • Vvelarde's avatar
        Vvelarde
        Community Champion
        9 years ago

        Anonymous

         

        The measure fail becasuse There is not a unique Calendar's Month selected, in the chart this work because your Axis is the each month so Values is a unique row.

         

        What is the %  that you want to show