Comparing Two period slicer selection

Hi ,

I have months under slicer and i want to arrive difference between two selected period based on the selection.

(Based on the latest month selcted and selected previous period)

Arriving perivious period value i am having zero with below dax calculatrion. can anyone help me out.

Previous period calculation i am not getting right values.

Thanks,

Mani

Need Help

v-yingjl

6 years ago

Hi Mani_ms ,

I found that you filtered the group = BS in the matrix so I created a slicer for the group field and the following measure if I got it correctly:

Measure = 
VAR _group =
    SELECTEDVALUE ( 'FMA 011 CY'[Group] )
VAR _maxfis =
    CALCULATE (
        MAX ( 'FMA 011 CY'[Fiscal Year/Period] ),
        ALLSELECTED ( 'FMA 011 CY'[Fiscal Year/Period] )
    )
VAR _minfis =
    CALCULATE (
        MIN ( 'FMA 011 CY'[Fiscal Year/Period] ),
        ALLSELECTED ( 'FMA 011 CY'[Fiscal Year/Period] )
    )
VAR _max =
    CALCULATE (
        SUM ( 'FMA 011 CY'[Balance - Cumulative] ),
        'FMA 011 CY'[Group] = _group,
        'FMA 011 CY'[Fiscal Year/Period] = _maxfis
    )
VAR _min =
    CALCULATE (
        SUM ( 'FMA 011 CY'[Balance - Cumulative] ),
        'FMA 011 CY'[Group] = _group,
        'FMA 011 CY'[Fiscal Year/Period] = _minfis
    )
RETURN
    _max - _min

Attached sample file: fille.pbix

Best Regards,
Yingjie Li

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

12 Replies

Greg_Deckler
Community Champion
6 years ago
Mani_ms You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000

Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008

But, not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
- Mani_ms
  Helper I
  6 years ago
  Hi,
  
  Material quite useful. Ultimately what i am trying to get output is based on the selected months want to identify the difference between the selected value .
  
  would be great if you could help on that.
v-yingjl
Community Support
6 years ago
Hi Mani_ms ,
Try like this measure:
Diff = VAR _max = CALCULATE ( MAX ( 'Table'[Sales] ), ALLSELECTED ( 'Table'[Month] ) ) VAR _min = CALCULATE ( MIN ( 'Table'[Sales] ), ALLSELECTED ( 'Table'[Month] ) ) RETURN _max - _min

Attached a sample file that hopes to help you: Comparing Two period slicer selection.pbix

Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
- Mani_ms
  Helper I
  6 years ago
  Hi,
  
  Thanks for your inputs, seems somehow i am missing the expected result. attached PBI file
  
  Expected result
  would be great if you could help on this?
  Thanks,
  Mani
  - Mani_ms
    Helper I
    6 years ago
    Hi,
    
    Thanks for your input.
    Its working for the Max and Min values and difference is am getting wrong number.