Forum Discussion

stellis's avatar
stellis
Frequent Visitor
3 years ago
Solved

Argument '2' in CALCULATE function is required.

I have the following code and get this error message: Argument '2' in CALCULATE function is required.   CODE: %PO_NEU = IF(         ISFILTERED('07_DateTable'[Month Name]),         CALCULATE( ...
Need Help
  • DOLEARY85's avatar
    DOLEARY85
    3 years ago

    Hi,

     

    try taking out that last comma

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Anonymous's avatar
Anonymous
Not applicable
2 years ago
I entered the following code and encountered this error message:  Argument '2' in CALCULATE function is required. 
 
 
1  Next Date DD REJ =
2  VAR _Result =
3  MAXX(
4           ADDCOLUMNS(
5                    SUMMARIZE('DD rejection summ','DD rejection summ'[Customer account number],'DD rejection summ'[Account Name], 'DD rejection summ'[Date]),
6                    "Dates",
7                    CALCULATE(
8                            MINX(FILTER(ALL('DD rejection summ'),'DD rejection summ'[Date] > SELECTEDVALUE('DD rejection summ'[Date])),'DD rejection summ'[Date]),
9                             )
10                   ), [Date])
11  RETURN IF(ISBLANK(_Result), "", _Result)
 
Please help identify what is wrong.
  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    2 years ago

    Hi,

    Share some data to work with, explain the question and show the expected result.  Share data in a format that can be pasted in an MS Excel file.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi Ashish, not sure my my reply did not reflected here, i already replied to your message 6 times.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Here's the details please.

      Account Name   Customer account number     Date DD REJ       Prev Date DD REJ     Next Date DD REJ

      Solaire                12619154                                 7/1/2024                                          shld be 7/2/2024- 

      Solaire               12619154                                  7/2/2024            7/1/2024                 shld be 7/3/2024- 

      Solaire               12619154                                 7/3/2024            7/2/2024

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

        With just that much information, I cannot help you.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      here's sample details pls. I screenshot, hope this will work. 

      i entered the above mentioned code in Power BI Desktop but in Next Date DD REJ column I encountered an error, Argument '2' in CALCULATE function is required. 

      Let me know if there's a need for further details. thank you so much for the help