Forum Discussion
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 ...
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 ?
Thanks for your quick 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, what is the logic of the calculated vlaues previous month,and do you use the today() to define the current month?
Best Regards!
Yolo Zhu