Forum Discussion

fab196's avatar
fab196
Helper II
4 years ago
Solved

YEAR WISE DATA

hi Sir, please help  me with following scenario.   1.by default without selecting any Financial year it should show Current FY Sales(max financial year ) & Prev FY Sales. and if i am selectiong t...
Need Help
Show and Tell
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    4 years ago

    fab196 , change the logic on your FY Start date

     

    This FYTD=
    var _max = if(isfiltered('Date'),MAX( 'Date'[Date]) , today())
    var _min =if( Month(_max) <4 , date(year(_max)-1,4,1) ,date(year(_max),4,1)), //FY April -March
    return
    CALCULATE([net] ,DATESBETWEEN('Date'[Date],_min,_max))

     

    This FYTD=
    var _max1 = if(isfiltered('Date'),MAX( 'Date'[Date]) , today())
    var _max = date(year(_max)-1,month(_max),day(_max))
    var _min =if( Month(_max) <4 , date(year(_max)-1,4,1) ,date(year(_max),4,1)), //FY April -March
    return
    CALCULATE([net] ,DATESBETWEEN('Date'[Date],_min,_max))

     


    This LFY Complete=
    var _max1 = if(isfiltered('Date'),MAX( 'Date'[Date]) , today())
    var _min =if( Month(_max1) <4 , date(year(_max1)-2,4,1) ,date(year(_max1)-1,4,1)), //FY April -March
    var _max =if( Month(_max1) <4 , date(year(_max1)-1,3,31) ,date(year(_max1),3,31)), //FY April -March
    return
    CALCULATE([net] ,DATESBETWEEN('Date'[Date],_min,_max))

amitchandak's avatar
amitchandak
Super User
4 years ago

fab196 , change the logic on your FY Start date

 

This FYTD=
var _max = if(isfiltered('Date'),MAX( 'Date'[Date]) , today())
var _min =if( Month(_max) <4 , date(year(_max)-1,4,1) ,date(year(_max),4,1)), //FY April -March
return
CALCULATE([net] ,DATESBETWEEN('Date'[Date],_min,_max))

 

This FYTD=
var _max1 = if(isfiltered('Date'),MAX( 'Date'[Date]) , today())
var _max = date(year(_max)-1,month(_max),day(_max))
var _min =if( Month(_max) <4 , date(year(_max)-1,4,1) ,date(year(_max),4,1)), //FY April -March
return
CALCULATE([net] ,DATESBETWEEN('Date'[Date],_min,_max))

 


This LFY Complete=
var _max1 = if(isfiltered('Date'),MAX( 'Date'[Date]) , today())
var _min =if( Month(_max1) <4 , date(year(_max1)-2,4,1) ,date(year(_max1)-1,4,1)), //FY April -March
var _max =if( Month(_max1) <4 , date(year(_max1)-1,3,31) ,date(year(_max1),3,31)), //FY April -March
return
CALCULATE([net] ,DATESBETWEEN('Date'[Date],_min,_max))

fab196's avatar
fab196
Helper II
4 years ago

hi sir,

it is not working for me