Forum Discussion

Jensej's avatar
Jensej
Helper 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...
amitchandak's avatar
amitchandak
Super User
5 years ago

Jensej , In a table visual take name, Resign_Date and this measure

 

measure  =calculate(countrows(Table), filter(Table, Table[Entry_Date] <=Today() && Table[Resign_Date] >=Today()))

Jensej's avatar
Jensej
Helper 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
    Super User
    5 years ago

    Jensej , Can you share your measure

    • Jensej's avatar
      Jensej
      Helper 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
        Super 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)))