Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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.