Forum Discussion

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

SQL into Dax

Hello!   I have a table in Power Bi with a Month Column Jan-Dec for year 2020. Now i want to a second column that shows the people who resigned in that month.  In sql i would solve it like this bu...
Jensej's avatar
Jensej
Icon for Helper V rankHelper V
5 years ago

HI amitchandak  

 

Thanks for your reply, if i do this i get this error message in the table visual. "A table of multiple values was supplied where a single value was expected"

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Jensej , Can you share your measure

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

     

     

    Measure 2 = 
VAR first= min(JF_BI_Datum[Datum])
VAR last= max(JF_BI_Datum[Datum])

RETURN
calculate(countrows(JF_BI_Adr), filter(JF_BI_Adr,DATESBETWEEN(JF_BI_Adr[Resign_Date],first,last)))

     

     

    • amitchandak's avatar
      amitchandak
      Icon for Super User rankSuper User
      5 years ago

      Jensej , Try like

       

      Measure 2 =
      VAR first= minX(allselected(JF_BI_Datum), JF_BI_Datum[Datum])
      VAR last= maxX(allselected(JF_BI_Datum),JF_BI_Datum[Datum])

      RETURN
      calculate(countrows(JF_BI_Adr), filter(JF_BI_Adr,DATESBETWEEN(JF_BI_Adr[Resign_Date],first,last)))

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

        Sadly still the same error 😞