Forum Discussion

Mohammadwazeri's avatar
Mohammadwazeri
Icon for Helper III rankHelper III
4 years ago
Solved

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

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...
Need Help
  • negi007's avatar
    negi007
    4 years ago

    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

negi007's avatar
negi007
Icon for Community Champion rankCommunity Champion
4 years ago

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