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

[colacan]

Not clear with your requirement... If your intention is to get some values for whole current Q, Next Q and next 2 Q,  you can create them using PARAELLPERIOD as CALCULATE filter. let's say you want to get [sales] then

(I assumed you have compleat Date table)

CurrentQ = CALCULATE([sales],PARAELLPERIOD(date[date],0,QUARTER)  // Current quater sales total

NextQ = CALCULATE([sales],PARAELLPERIOD(date[date],+1,QUARTER)
Next2Q = NextQ +CALCULATE([sales],PARAELLPERIOD(date[date],+2,QUARTER)

Hope this helps you. Thanks

Please mark as solution if this solved your issue.