Forum Discussion

lnjwilliamson86's avatar
lnjwilliamson86
Frequent Visitor
8 years ago
Solved

Calculating % Variance between YTD & LYTD

Hi,    I am trying to calculate the variance % between a YTD and LYTD. However my formulas are giving me incorrect results.  I have monthly data over two financial years for various metrics in my ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    You will have to select a month for the TOTALYTD() function to work.  Only then will it know where it has to sum till.  If your Financial Year starts on July 1 and you select October as the month in the filter/slicer, your measure will sum up the numeric column from JUly 1 to October 31.

lnjwilliamson86's avatar
lnjwilliamson86
Frequent Visitor
8 years ago

After some further investigating (aka messing around) I have realised that if i select the three months in this FY to date in a visual level filter the variance and % variance results work. 

 

Can someone help me with some DAX code to ensure that my variance and % variance measures will work so that I don't need to use the month visual level filter. 

 

 

Thanks :) 

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

You will have to select a month for the TOTALYTD() function to work.  Only then will it know where it has to sum till.  If your Financial Year starts on July 1 and you select October as the month in the filter/slicer, your measure will sum up the numeric column from JUly 1 to October 31.