Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Last 3 month

hello friends, i want out put like current month is december i set that as per letest data . now i need have output like Dec -17 is cureent month and last 2 Month like set flag true other ...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Hi Anonymous

     

    Do you sepcify the last month year manually?...IN that case you can use something like..

     

    You can define last month and year in the current date

     

    Column =
VAR CurrentDate =
    DATE ( 2017, 12, 31 )
VAR StartingPoint =
    EOMONTH ( CurrentDate, -3 ) + 1
RETURN
    Table1[Date]
    >= StartingPoint
    && Table1[Date] <= CurrentDate

     

     

  • Anonymous's avatar
    Anonymous
    8 years ago

    =var monthdiff= if(Month_Year[Date]<=Month_Year[Current Date],- datediff(Month_Year[Date], Month_Year[Current Date],MONTH),datediff(Month_Year[Current Date],Month_Year[Date],MONTH)) return monthdiff >=-2 && monthdiff<=0

     

     

    i use like this and its work

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

Hi Anonymous

 

If you want Current YEAR MONTH to be the last YEAR MONTH in your data... you can use somehting like this

 

Column =
VAR CurrentDate =
    MAX ( Table1[Date] )
VAR StartingPoint =
    EOMONTH ( CurrentDate, -3 ) + 1
RETURN
    Table1[Date]
    >= StartingPoint
    && Table1[Date] <= CurrentDate
Anonymous's avatar
Anonymous
Not applicable
8 years ago

=var monthdiff= if(Month_Year[Date]<=Month_Year[Current Date],- datediff(Month_Year[Date], Month_Year[Current Date],MONTH),datediff(Month_Year[Current Date],Month_Year[Date],MONTH)) return monthdiff >=-2 && monthdiff<=0

 

 

i use like this and its work