Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

DAX NB

Hello, I have a problem: on power bi I have a table that contains several columns and among these columns, I have a measure that determines the number of vehicles planned/synchronized. Here is the...
amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , based on what I got so far, new measures like

 

Nbr_VHS_ScheduledSynchronized remining for this month = CALCULATE(SUM('db_infocentre PX_installCR'[nb_box]), filter('db_infocentre PX_intervention', OR('db_infocentre PX_intervention'[status]="IN_PROGRESS" , 'db_infocentre PX_intervention'[status]="SCHEDULED") && 'db_infocentre PX_intervention'[Date] >= Today() && 'db_infocentre PX_intervention'[date] <= eomonth(Today(), 0)))

 

Nbr_VHS_ScheduledSynchronized remining till next month = CALCULATE(SUM('db_infocentre PX_installCR'[nb_box]), filter('db_infocentre PX_intervention', OR('db_infocentre PX_intervention'[status]="IN_PROGRESS" , 'db_infocentre PX_intervention'[status]="SCHEDULED") && 'db_infocentre PX_intervention'[Date] >= Today() && 'db_infocentre PX_intervention'[date] <= eomonth(Today(), 1)))

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Okay thank you. What means  : eomonth(Today(), 1)))

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      EOMONTH returns the date in datetime format of the last day of the month before or after a specified number of months.
      So eomonth(Today(), 1) returns the last date of the next month with respect to the current month.

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Okay, and if I want to do Nbr_VHS_ScheduledSynchronized remining month+x, do you have idea of how can I do?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    for month +2 is it : 

     

    Nbr_VHS_ScheduledSynchronized remining till next month = CALCULATE(SUM('db_infocentre PX_installCR'[nb_box]), filter('db_infocentre PX_intervention', OR('db_infocentre PX_intervention'[status]="IN_PROGRESS" , 'db_infocentre PX_intervention'[status]="SCHEDULED") && 'db_infocentre PX_intervention'[Date] >= Today() && 'db_infocentre PX_intervention'[date] <= eomonth(Today(), 2)))