Forum Discussion

Mohammadwazeri's avatar
Mohammadwazeri
Helper 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

Mohammadwazeri's avatar
Mohammadwazeri
Helper III
4 years ago

Thank you so much, it's working.