Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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")))) |
Solved! Go to Solution.
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
Linkedin
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
Linkedin
User | Count |
---|---|
83 | |
69 | |
68 | |
65 | |
53 |
User | Count |
---|---|
94 | |
92 | |
91 | |
77 | |
70 |