Forum Discussion

corbincdc's avatar
corbincdc
Frequent Visitor
6 years ago

Adding missing dates each category for a kpi dashboard

Hello - We are setting up a KPI dashboard we have target value of 10 records each day per Property Name .  I have already aggrigated the data for the number of records per day.  This shown below.  My...
Need Help
corbincdc's avatar
corbincdc
Frequent Visitor
6 years ago

Thanks for the repy.  However, I am not seeing where this would add dates for all the different properties.  The first set of data below is the original data and the second one is what it needs to show. 

 

Data Set Original  
Property NameDate 
5Fifty51/18/2020
5Fifty51/20/2020
5Fifty51/22/2020
5Fifty51/24/2020
5Fifty51/27/2020
7th Street Brownstones1/18/2020
7th Street Brownstones1/20/2020
7th Street Brownstones1/22/2020
7th Street Brownstones1/24/2020
7th Street Brownstones1/27/2020
  
Transform to:  
5Fifty51/18/2020
5Fifty51/19/2020
5Fifty51/20/2020
5Fifty51/21/2020
5Fifty51/22/2020
5Fifty51/23/2020
5Fifty51/24/2020
5Fifty51/25/2020
5Fifty51/26/2020
5Fifty51/27/2020
7th Street Brownstones1/18/2020
7th Street Brownstones1/19/2020
7th Street Brownstones1/20/2020
7th Street Brownstones1/21/2020
7th Street Brownstones1/22/2020
7th Street Brownstones1/23/2020
7th Street Brownstones1/24/2020
7th Street Brownstones1/25/2020
7th Street Brownstones1/26/2020
7th Street Brownstones1/27/2020
  • Icey's avatar
    Icey
    Community Support
    6 years ago

    Hi corbincdc ,

     

    Please check if this can meet your requirements:

     

    1. Create a Calendar table.

    Calendar = CALENDAR( MIN( 'Table'[Date] ), MAX( 'Table'[Date] ) )

     

    2. Create relationships between the two tables.

     

    3. Create Measures.

    For numerical columns, create measures like so:

    Value Measure = SUM( 'Table'[Value] ) + 0

     For text columns, create measures like so:

    Text Measure = IF ( MAX ( 'Table'[Text] ) = BLANK (), "NULL", MAX ( 'Table'[Text] ) )

     

    4. Create Table visuals.

     

    For more details, please check the attached PBIX file.

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.