Forum Discussion

Asfaa5's avatar
Asfaa5
Frequent Visitor
6 years ago
Solved

Active Contracts Count by Year/Month

Hello Team,   im new to Power Bi. I need a help on Dax Measure calculation of Active Contracts Count by Year/Month.   I have a Table "Sales" with 7,65,000 data. Sales Table contains "Policy Numbe...
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Asfaa5 

    Create one date table.

     

    Date=Calender(DATE (2010, 1, 1), DATE (2020, 12, 31)).

    Then create year and month column in the date table.

     

    Then create measure suggested by Anonymous .

     

    And add year, month and measure to your table visual.

     

    Thanks & regards,
    Pravin Wattamwar
    www.linkedin.com/in/pravin-p-wattamwar

    If I resolve your problem Mark it as a solution and give kudos.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

What is the required logic for active contracts?

 

Is it where end date in blank() or 12/31/9999?

 

New measure=Calculate(Count[Table[Contract]),Filter(table,Table[end_Date]='12/31/9999')

 

Please modify filter condition as per your active contracts logic.

 

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.

Asfaa5's avatar
Asfaa5
Frequent Visitor
6 years ago

Hi. Thanks for your revert.

 

Logic is for Showing How many Contract are going to be active in Jan-20, Feb-20, Mar-20, like this till Contract Expire completely.

 

There is no blank in Contract End Date. Last date is till 31/12/2027.