Forum Discussion

Taznalem's avatar
Taznalem
Frequent Visitor
7 years ago
Solved

How to create calculate spells ?

Hi everybody!   I am developing a PBI to have a tracking of trainings. I would like have a Card where show the maximum number of days of training non-stop. If we suppose one month   1. A Calendar...
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi Taznalem,

     

    Please check out the demo in the attachment. The main steps are as follows.

    1. Create an index that can identify the continuous days. 

    How_to_create_calculate_spells

    2. Create a measure. 

    Measure =
MAXX (
    SUMMARIZE (
        'Table1',
        'Table1'[Index],
        "non-stop", COUNT ( 'Table1'[Training] )
    ),
    [non-stop]
)

    How_to_create_calculate_spells2

    Best Regards,
    Dale

Taznalem's avatar
Taznalem
Frequent Visitor
7 years ago

Hi everybody! I am developing a PBI to have a tracking of trainings. I would like have a Card where show the maximum number of days of training non-stop. If we suppose one month:

 

1. A Calendar with all days of the month

2. A Query with the trainings. These are classified by days and include all the relevant information about the trainings

 

The question if that I don't know how to calculate the maximum number of days that I have been training non-stop along the month. Thanks in advance

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    7 years ago

    Hi,

     

    Share some data and show the expected result.