Forum Discussion

619SK's avatar
619SK
Helper II
2 years ago

Report view for weekly report with condition

Here my ask is to add "point" column based upon sample data.  have added sample data along with condition.

1) How to calculate point based upon condition  and add in report view with weeks filter

2) How to show particular Age category count 0 as when i added week filter then it shows only those who are having value.

 

Sample data

 

Need Help

6 Replies

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    2 years ago

    Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
    If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
    Please show the expected outcome based on the sample data you provided.

    If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

  • 619SK's avatar
    619SK
    Helper II
    2 years ago

    Syndicate_Admin Below is sample input data and i added outcome expected result.

    Start DateDefect StatusStart of WeekAgeAge Category
    18-12-2023Open18-12-20231090-180 Days
    18-12-2023Open18-12-2023100-15 Days
    19-12-2023Open18-12-20239>180 Days
    19-12-2023Open18-12-20239>180 Days
    19-12-2023Open18-12-2023990-180 Days
    19-12-2023Open18-12-20239>180 Days
    19-12-2023Open18-12-20239>180 Days
    19-12-2023Close18-12-20239>180 Days

     

    Outcome result in BI

     

    • Syndicate_Admin's avatar
      Syndicate_Admin
      Administrator
      2 years ago

      Your age and Age Category columns are inconsistent. Please provide usable sample data.  Please also provide the lookup table in usable format.

  • 619SK's avatar
    619SK
    Helper II
    2 years ago

    Sample data

    Start DateDefect StatusStart of WeekAgeAge Category
    16-11-2023Open13-11-20234230-60 Days
    20-11-2023Open20-11-20233830-60 Days
    29-11-2023Open27-11-20232915-30 Days
    07-12-2023Open04-12-20232115-30 Days
    10-12-2023Open04-12-20231815-30 Days
    16-12-2023Open11-12-2023120-15 Days
    18-12-2023Open18-12-2023100-15 Days
    18-12-2023Open18-12-2023100-15 Days
    19-12-2023Open18-12-202390-15 Days
    19-12-2023Open18-12-202390-15 Days
    19-12-2023Open18-12-202390-15 Days
    19-12-2023Open18-12-202390-15 Days
    19-12-2023Open18-12-202390-15 Days
    19-12-2023Open18-12-202390-15 Days
    19-12-2023Open18-12-202390-15 Days
    19-12-2023Open18-12-202390-15 Days
    19-12-2023Open18-12-202390-15 Days
    19-12-2023Open18-12-202390-15 Days
    19-12-2023Open18-12-202390-15 Days
    19-12-2023Open18-12-202390-15 Days
    19-12-2023Open18-12-202390-15 Days
    19-12-2023Open18-12-202390-15 Days
    19-12-2023Open18-12-202390-15 Days
    19-12-2023Open18-12-202390-15 Days
    19-12-2023Open18-12-202390-15 Days
    19-12-2023Open18-12-202390-15 Days
    19-12-2023Open18-12-202390-15 Days
    19-12-2023Open18-12-202390-15 Days
    19-12-2023Open18-12-202390-15 Days
    19-12-2023Open18-12-202390-15 Days
    19-12-2023Open18-12-202390-15 Days
    19-12-2023Open18-12-202390-15 Days
    19-12-2023Open18-12-202390-15 Days
    19-12-2023Open18-12-202390-15 Days
    19-12-2023Open18-12-202390-15 Days
    19-12-2023Open18-12-202390-15 Days
    19-12-2023Open18-12-202390-15 Days
    19-12-2023Open18-12-202390-15 Days
    19-12-2023Open18-12-202390-15 Days
    19-12-2023Open18-12-202390-15 Days
    19-12-2023Open18-12-202390-15 Days
    19-12-2023Open18-12-202390-15 Days
    19-12-2023Open18-12-202390-15 Days
    19-12-2023Open18-12-202390-15 Days
    19-12-2023Open18-12-202390-15 Days
    19-12-2023Open18-12-202390-15 Days
    19-12-2023Open18-12-202390-15 Days
    19-12-2023Open18-12-202390-15 Days
    19-12-2023Open18-12-202390-15 Days
    19-12-2023Open18-12-202390-15 Days
    19-12-2023Open18-12-202390-15 Days
    19-12-2023Open18-12-202390-15 Days
    19-12-2023Open18-12-202390-15 Days
    19-12-2023Open18-12-202390-15 Days
    19-12-2023Open18-12-202390-15 Days
    19-12-2023Open18-12-202390-15 Days
    19-12-2023Open18-12-202390-15 Days
    21-12-2023Open18-12-202370-15 Days

     

    Power BI outcome :-

    Age CategoryOpen Defect CountPointsRAG
    >180 Days30Red
    90-180 Days0100Green
    0-15 Days5380Green
    15-30 Days3100Green
    60-90 Days0100Green
    30-60 Days290Green