Forum Discussion

Pricey79's avatar
Pricey79
Icon for Helper V rankHelper V
5 years ago
Solved

Date Query

Hello I have a problem that I cant solve. I have a column in date form titled required date. I would like to know how I could get a card to show me how many items are due in the next two weeks, and...
Need Help
  • manikumar34's avatar
    manikumar34
    5 years ago

    Pricey79 . 

     

    You are not closing DISTINCTCOUNT. 

     

    Please use ) after giving the column. 

     

    Regards, 

    Manikumar

     

    If you think this is helpful Please Accept as Solution and leave a like

manikumar34's avatar
manikumar34
Icon for Solution Sage rankSolution Sage
5 years ago

Pricey79 ,

Use the below to check the last 14 days distinct values. 

 

Measure =
CALCULATE(DISTINCTCOUNT('Table'[Value]),DATESINPERIOD(LASDATE('Table'[Date]),-14,DAY))

Pricey79's avatar
Pricey79
Icon for Helper V rankHelper V
5 years ago

manikumar34 

Thank you for your reply. 

Using your solution I get the error message :

 

Too few arguments were passed in DATESINPERIOD fucntion. The minium argument count for the function is 4 

 

 

  • manikumar34's avatar
    manikumar34
    Icon for Solution Sage rankSolution Sage
    5 years ago

    Pricey79 , hey Sorry. 

     

    I was missing to refre the Dates columns. 

     

    Measure =
    CALCULATE(DISTINCTCOUNT('Table'[Value]),DATESINPERIOD('Table'[Date],LASDATE('Table'[Date]),-14,DAY))

     

    Check with the above

     

    Reards, 

    Manikumar

    • Pricey79's avatar
      Pricey79
      Icon for Helper V rankHelper V
      5 years ago

      manikumar34 

       

      thank you, but I still get the below:

       

       

      • manikumar34's avatar
        manikumar34
        Icon for Solution Sage rankSolution Sage
        5 years ago

        Pricey79 . 

         

        You are not closing DISTINCTCOUNT. 

         

        Please use ) after giving the column. 

         

        Regards, 

        Manikumar

         

        If you think this is helpful Please Accept as Solution and leave a like