Forum Discussion

Velias's avatar
Velias
Regular Visitor
9 years ago
Solved

Date range on visualization

Greetings! Please tell me how I can add to the visualization tools dashboards date range, as well as the opportunity to compare the two ranges and display the percentage difference?
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi Velias,

    You can write the following formulas to calculate percent difference. For mor details, please review the example in the attached PBIX file.

    1. Create a measure that calculate sessions between 2016,9,5 and 2016,9,7.
    Sessionsum = CALCULATE(SUM(Table2[Sessions]), DATESBETWEEN(Table2[Date],DATE(2016,9,5), DATE(2016,9,7)))

    2. Create a measure that calculate sessions difference between two date ranges.
    Session difference = CALCULATE(SUM(Table2[Sessions]), DATESBETWEEN(Table2[Date],DATE(2016,9,9), DATE(2016,9,11)))-CALCULATE(SUM(Table2[Sessions]), DATESBETWEEN(Table2[Date],DATE(2016,9,5), DATE(2016,9,7)))

    3. Create a measure that calculate percent difference and format the measure using the following percentage option.
    Percent difference = DIVIDE([Session difference],[Sessionsum])


    Thanks,
    Lydia Zhang

Velias's avatar
Velias
Regular Visitor
9 years ago

Thanks Anonymous!

 

Timeline custom visual - good thing.

 

To solve their problems I need to compare periods. For example a visit to the site 09.05.2016 - 11.09.2016 compared with 29/08/2016 - 09/04/2016 or 08/09/2016 compared to 04/08/2016. Need a percentage of the difference of the two periods specified manually.

Example: site visits in the period 05.09.2016 - 11.09.2016 up 25 percent of visits to the site 08/29/2016 - 04/09/2016

Sorry for my English :(

 

 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Velias,


Could you please post sample data with a table ?

Thanks,
Lydia Zhang

  • Velias's avatar
    Velias
    Regular Visitor
    9 years ago
    DateSessions
    05.09.20161000
    06.09.20161500
    07.09.20161500
    08.09.2016900
    09.09.20161200
    10.09.20162000
    11.09.20162500

     

    for example: 09.09.2016 - 11.09.2016 above 43% than 05.09.2016 - 07.09.2016 etc.

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi Velias,

      You can write the following formulas to calculate percent difference. For mor details, please review the example in the attached PBIX file.

      1. Create a measure that calculate sessions between 2016,9,5 and 2016,9,7.
      Sessionsum = CALCULATE(SUM(Table2[Sessions]), DATESBETWEEN(Table2[Date],DATE(2016,9,5), DATE(2016,9,7)))

      2. Create a measure that calculate sessions difference between two date ranges.
      Session difference = CALCULATE(SUM(Table2[Sessions]), DATESBETWEEN(Table2[Date],DATE(2016,9,9), DATE(2016,9,11)))-CALCULATE(SUM(Table2[Sessions]), DATESBETWEEN(Table2[Date],DATE(2016,9,5), DATE(2016,9,7)))

      3. Create a measure that calculate percent difference and format the measure using the following percentage option.
      Percent difference = DIVIDE([Session difference],[Sessionsum])


      Thanks,
      Lydia Zhang