Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Stop accumulative line

Hi All,   I need your help. I have graph showing accumulative lines of forecast, actual etc.   i used this qury to make lines in graph. CSU SP_Contractual = CALCULATE(     COUNTA('Data - CS...
Need Help
Show and Tell
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous , try like

 

You try using the date from table in max

 

CSU SP_Contractual =
CALCULATE(
COUNTA('Data - CSU SP PO'[CONTRACTUAL_DELIVERY_DATE]), USERELATIONSHIP('Data - CSU SP PO'[CONTRACTUAL_DELIVERY_DATE],'calendar'[Date]),
FILTER(
ALLSELECTED('Calendar'[Date]),
'Calendar'[Date]<= MAX('Data - CSU SP PO'[CONTRACTUAL_DELIVERY_DATE])))

 

 

Can you share sample data and sample output in table format?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    hi amitchandak  

     

    i tried the formular and the graph doesn't look right..

     

    • v-kelly-msft's avatar
      v-kelly-msft
      Icon for Community Support rankCommunity Support
      6 years ago

      Hi  Anonymous ,

       

      Can you pls upload your .pbix file to onedrive business and share the link with us?

       

      Remember to remove the confidential information.

       

      Best Regards,
      Kelly
      Did I answer your question? Mark my post as a solution!