Forum Discussion

dluhut's avatar
dluhut
Frequent Visitor
9 years ago

DAX YTD via PowerPivot

Hello,   I am using Excel 2013 PowerPivot. Thus would appreciate if you could help me out using DAX that's in PowerPivot Excel 2013.   What I am trying to accomplished here is to have the YTD.  ...
Need Help
dluhut's avatar
dluhut
Frequent Visitor
9 years ago

Any experts here able to help me out?

 

I believe my problem is that, the slicer 'Month' is taken from the 'Calendar Date Table'.

 

However, my DAX formula here is not taking into consideration the 'link' between 'Calendar Date Table' and 'Fiscal Calendar DateTable'.

 

Thus, is there a way for the YTD to know taking the beginning to the 'end' of the month of the 'Fiscal Calendar DateTable' via the 'Month' slicer of 'Calendar Date Table'?

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    HI dluhut.


    For these refer links which you mention, they use the calculated column to get the result. Please make sure if you are use these formula in calculated column.

     

    BTW, if your requirement is about power pivot, you can post it at below forum.

    Msdn forums - Power Pivot - Microsoft

     

    Regards,

    Xiaoxin Sheng

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    9 years ago

    Hi,

     

    Upload a summy dataseta and how your expected result