How Can I Create Current Quarter, Next Quarter, & Next two Quarters Fields?

[Mohammadwazeri]

Hi,

I need to get the answer for this ASAP.

I stuck in creating current, next, & next tow quarter fields in powerbi desktop, could you please give me an idea how to create these fields using dax or any other way in powerbi.

Thanks

Mohammad

[Mohammadwazeri]

Thank you so much, it's working.

[negi007 · Accepted solution]

@Mohammadwazeri  in this case, you can follow the below approach to create 3 measures

1. 

current qtr =

var cqtr = QUARTER(TODAY())

var cyear= YEAR(TODAY())

var curr = cyear & "Q" & cqtr

return

curr

2.

next1 qtr =

var cqtr = QUARTER(TODAY())

var cyear= YEAR(TODAY())

var next1 = IF(cqtr=4, cyear+1 & "Q1", cyear & "Q" & cqtr+1)

return

next1

3.

next2 qtr =

var cqtr = QUARTER(TODAY())

var cyear= YEAR(TODAY())

var next2 = IF(cqtr>=3, cyear+1 & "Q1", cyear & "Q" & cqtr+1)

return

next2

i hope it helps you