cancel
Showing results for
Did you mean:

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Helper I

## Dynamic Month value while using calculate and filter

How can i create dynamic value to use below month value in calculate & filter formulas

Calculate([Distcoun tofnumberMarid],Filter('Global',[mmyy]="Q1-2024 Mar",'Global',[Std]="Yes",Global',[Month]="Mar-24",'Global",[Testing month]="Mar"))))

 ABC Description Sample (Mar) Passing % _ABC Passing % XYZ TEST 1 40 90% 80% If Pending from prev month 0 TEST 3 30 90% 90 TEST 4 40 80% 100 TEST 5 40 70% 100 Table view in BI Sample (Dist Count for Mar) Calculate([Distcoun tofnumberMarid],Filter('Global',[mmyy]="Q1-2024 Mar",'Global',[Std]="Yes",Global',[Month]="Mar-24",'Global",[Testing month]="Mar"))))
1 ACCEPTED SOLUTION
Super User

Hi @619SK

I hope from measure, you will get Idea to create Dynamic value and as per your requirement you can update it. I am taking dynamic value as Current Month, Current Qtr and Current Year

``````= VAR _CurrentQuarterYearMonth = "Q"&QUARTER(Today())&"-"&YEAR(TOday())&" "&FORMAT(Today(),"Mmm")
VAR _CurrentQuarterMonth = FORMAT(Today(),"Mmm")&"-"&YEAR(TOday())
VAR _CurrentMonth = FORMAT(Today(),"Mmm")
RETURN
Calculate([Distcoun tofnumberMarid],Filter('Global',[mmyy]= _CurrentQuarterYearMonth ,'Global',[Std]="Yes",Global',[Month]=_CurrentQuarterMonth,'Global",[Testing month]=_CurrentMonth))))``````

Let me know if that works for you

If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

Thanks
Pijush

Super User

Hi @619SK

I hope from measure, you will get Idea to create Dynamic value and as per your requirement you can update it. I am taking dynamic value as Current Month, Current Qtr and Current Year

``````= VAR _CurrentQuarterYearMonth = "Q"&QUARTER(Today())&"-"&YEAR(TOday())&" "&FORMAT(Today(),"Mmm")
VAR _CurrentQuarterMonth = FORMAT(Today(),"Mmm")&"-"&YEAR(TOday())
VAR _CurrentMonth = FORMAT(Today(),"Mmm")
RETURN
Calculate([Distcoun tofnumberMarid],Filter('Global',[mmyy]= _CurrentQuarterYearMonth ,'Global',[Std]="Yes",Global',[Month]=_CurrentQuarterMonth,'Global",[Testing month]=_CurrentMonth))))``````

Let me know if that works for you

If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

Thanks
Pijush