Forum Discussion

GokilaRaviraj's avatar
GokilaRaviraj
Helper II
1 year ago

Calculations based on other 2 datasets

Hi, I have 2 input tables shown below CFY refers to Current FinYear and NFY refers to Next Finyear Total Income Company OctCFY NovCfy DecCFY JanNfy Febnfy Marnfy Aprnfy maynfy junnfy ...
Need Help
Tips and Tricks
GokilaRaviraj's avatar
GokilaRaviraj
Helper II
1 year ago

Hi Anonymous 

 

Thanks for your reply.  I tried this measure. 

I am wondering why the values are not coming for Febcfy,Maycfy,Augcfy,Novcfy even though you have given this code. 

GENERATESERIES ( 2, 23, 3 )
 
I also have a question on type table month data, Now this has months from Jan cfy to dec nfy.  But I want to show these months from jancfy to decnfy only when current month is Jan.
 
when Current month is Feb, It has to show months from Febcfy to decnfy and this calculations is not needed. It has to just carry out the calculated vlaues previous month. Calculation has to be done again , when current month becomes Jan the next year
 
Is this can be done in DAX ? 
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi GokilaRaviraj 

Thanks for your quicl reply, for the first question, because the data you provided is start from October, so it will return 0 for Febcfy,Maycfy,Augcfy,Novcfy 

For the second question,  I don't really know the results you want

 

Best Regards!

Yolo Zhu

 

  • GokilaRaviraj's avatar
    GokilaRaviraj
    Helper II
    1 year ago

    Hi Anonymous 

     

    Now I changed my 2 input tables with months from JanCFY to DecNFY.

    In the output table, Value is not showing up for FebCFY column alone. All other columns have values as per the measure.

     

    Do you have any idea on this ?

    • GokilaRaviraj's avatar
      GokilaRaviraj
      Helper II
      1 year ago

      Hi Anonymous 

       

      I have an another doubt here, This calculation has to be done only when current month is Jan. So i have put a condition like this in the measure, 

      IF(FORMAT(TODAY(), "MMMM") ="January", Do the calculation. But in else part, I need to just carry out the same value which was calculated on January. It should not again calculate anything, since my input tables will not have jan value to calculate May value.
       
      Is this can be done ?
      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        Hi GokilaRaviraj 

        There is no value in February because there is no value in the previous quarter based on February. Do you mean that February returns the value calculated in January? Then there is another question. If the current month is January, the calculation you described above is performed, and then the value calculated in January is returned. Do you need to perform the calculation performed in the second month of each subsequent quarter mentioned above? I am a little confused.

         

        Best Regards!

        Yolo Zhu