Forum Discussion

Mohammadwazeri's avatar
Mohammadwazeri
Icon for Helper III rankHelper III
5 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 any other way in powerbi.

 

Thanks

Mohammad

Need Help
  • negi007's avatar
    negi007
    5 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

2 Replies

  • negi007's avatar
    negi007
    Icon for Community Champion rankCommunity Champion
    5 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