Forum Discussion

FlimSpringfield's avatar
FlimSpringfield
New Member
2 years ago
Solved

Variance by Period without Date

Hi, 

 

I am relatively new to Power BI and have a dataset similar to the below:

 

 

I want to display the period on period changes in each status such that I need a visual which will display the following:

 

 

So I know that I need a measure which takes the difference between the counts for the current period and prior period but I cannot work out how to implement this into the Calcuate DAX function. 

 

I could not find an answer on the forums which did not contain dates but hopefully this has a quick answer and I am struggling a bit.

 

Thanks

Need Help
  • some_bih's avatar
    some_bih
    2 years ago

    Hi FlimSpringfield please try measure Test as below. I got results as yours, not only for period 3. It could be my typo or your data (not shown everything)

    Test =
    VAR __max_period=MAX('Table'[Period])

    RETURN
    COUNT('Table'[ID])-
    CALCULATE(
        COUNT('Table'[ID]),
        'Table'[Period]<__max_period
    )
     
    Output

     

1 Reply

  • some_bih's avatar
    some_bih
    Community Champion
    2 years ago

    Hi FlimSpringfield please try measure Test as below. I got results as yours, not only for period 3. It could be my typo or your data (not shown everything)

    Test =
    VAR __max_period=MAX('Table'[Period])

    RETURN
    COUNT('Table'[ID])-
    CALCULATE(
        COUNT('Table'[ID]),
        'Table'[Period]<__max_period
    )
     
    Output