Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago

Dax

Good afternoon community,

I would like to consult you how I could make a measurement in which it allows me to know the value of last year of the current month, also have a parameter of months which when selecting a value "n" decreases me in "n" months of the current month in the previous year.

Example:

next reference image

thank you very much in advance

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      coloque datos 0 sin relevancia porque solo mostraba hasta el mes 04/2022 

  • Duia's avatar
    Duia
    Resolver II
    4 years ago

    Hi  Syndicate_Admin ,

    Here are the steps you can follow：

    1. Modeling - New parameter - Create a 0-12 table as a slicer.

    2. Create measure.

    Measure =
var _select=SELECTEDVALUE('periodo'[periodo])
var _today=TODAY()
var _maxdate=MAXX(ALL('Table'),[Date])
return
IF(
    YEAR(MAX('Table'[Date]))=YEAR(TODAY())&&
    MAX('Table'[Date])<=DATE(YEAR(TODAY()),MONTH(_maxdate)-_select,1)
    ,
    CALCULATE(SUM('Table'[valor]),FILTER(ALL('Table'),
    'Table'[Date]=DATE(YEAR(MAX('Table'[Date]))-1,
    MONTH(MAX('Table'[Date]))+_select,1)))
    ,BLANK())

    3. Result:

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly