Measure to get last month of a quarter when selected from a Quarter slicer

[krishnakantht7]

Hello community, 

My doubt is that have a columns of Quarter and Period. Took a slicer and dragged Quarter & Period. Whenever I select Q1 in a slicer, it should select only P03(instead of P01, P02&P03), when i selected Q2, it should select only P06, similarly for Q3, it should select only P09 and for Q4, it should select only P12. 

Regards, 

Krishnakanth

[krishnakantht7]

Ok Thank you

Sent you a request in Linkedin with Name Thummalacherla Krishnakanth

 Like this error it is displaying when I'm trying

[Ashish_Mathur]

How can i help with by just looking at an image?

[krishnakantht7]

Ok Ashish, 

Got the code. Tried today. 

Code:

IHC2(1) =

var v1=SWITCH(

    TRUE(),

    SELECTEDVALUE(Headcount[Quarter])="Q1", calculate(sum(Headcount[Internal Headcount]), Headcount[Period]="P03"),

SELECTEDVALUE(Headcount[Quarter])="Q2",calculate(sum(Headcount[Internal Headcount]), Headcount[Period]="P06"),

SELECTEDVALUE(Headcount[Quarter])="Q3",calculate(sum(Headcount[Internal Headcount]), Headcount[Period]="P09"),

            SELECTEDVALUE(Headcount[Quarter])="Q4", calculate(sum(Headcount[Internal Headcount]), Headcount[Period]="P12")

            )

             var v2=IF(ISFILTERED(Headcount[Quarter]), v1, calculate(sum(Headcount[Internal Headcount]), Headcount[Period]="P12"))

             RETURN

             v2

[v-yiruan-msft · Accepted solution]

Hi @krishnakantht7 ,

Did you get your expected result? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

Best Regards

[krishnakantht7]

Hello yingyinr,

It has helped me.

Thank you.

Regards,

Krishnakanth

[Ashish_Mathur]

Hi,

You should create a Calendar Table with columns there for Year, Quarter and Period.  In your source data table, ensure you have a proper Date column and if you do not have one, then create one with the information you have in ther other columns.

Thereafter you should be able to write a measure with functions such as datesbetween(), max() and calculate().

If you need an further help, then share the link from where i can download your PBI file and show the expected result very clearly.