Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago
Solved

Subtract and get less previous current date quantity

Hello powerbi community, cordial greeting.

Again I am here to ask for support, I am needing to create a new calculated column that brings me the difference that exists between the minor date and the next date of people.

For example: If on 26/03/2020 I have 5 people, then the difference against the previous date which is 19/03/2020 is 2. Because the 5 - 3 = 2 is subtracted.

Attached example image, result to get column Dif_por_dia.

WolterNet_0-1645674204780.png

In advance thank you very much always for your support.

Cordially

Wolter

  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    I tried to create similar sample data like below.

    Please check the below picture and the attached pbix file.

     

     

    Dif_por_dia CC =
    VAR currentdatevalue = Data[Cantidad_Personas]
    VAR currentdate = Data[Date]
    VAR previousdate =
    MAXX ( FILTER ( Data, Data[Date] < currentdate ), Data[Date] )
    VAR previousdatevalue =
    MAXX ( FILTER ( Data, Data[Date] = previousdate ), Data[Cantidad_Personas] )
    RETURN
    currentdatevalue - previousdatevalue

2 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    4 years ago

    Hi,

    I tried to create similar sample data like below.

    Please check the below picture and the attached pbix file.

     

     

    Dif_por_dia CC =
    VAR currentdatevalue = Data[Cantidad_Personas]
    VAR currentdate = Data[Date]
    VAR previousdate =
    MAXX ( FILTER ( Data, Data[Date] < currentdate ), Data[Date] )
    VAR previousdatevalue =
    MAXX ( FILTER ( Data, Data[Date] = previousdate ), Data[Cantidad_Personas] )
    RETURN
    currentdatevalue - previousdatevalue