Forum Discussion

Mani_ms's avatar
Mani_ms
Helper I
6 years ago
Solved

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 ...
Need Help
  • v-yingjl's avatar
    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.

Mani_ms's avatar
Mani_ms
Helper I
6 years ago

v-yingjl  Thanks for your input.

 

I am new to community , How to upload files in the community portal. i have business one drive there i can't share the information outside. could you pls suggest alernate way.

v-yingjl's avatar
v-yingjl
Community Support
6 years ago

Hi Mani_ms ,

You can upload the dummy file to OneDrive for Business etc which can store files and just share this file link in the community.

 

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's avatar
    Mani_ms
    Helper I
    6 years ago

    v-yingjl 

    Please find the below dummy file for your reference. would be great if you could assist on this.

    sample file 

     

    Thanks

    Mani

    • v-yingjl's avatar
      v-yingjl
      Community Support
      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.

      • Mani_ms's avatar
        Mani_ms
        Helper I
        6 years ago

        v-yingjl  thank you very much. Its perfectly working as per my expectation..Thank you once again