Below calculate newly won project work sourced from project variation, it checks a few
things:
1. restrict the calculations to projects exists from previous month;
2. the formula can also calculate accumulated nww spanned multipel month
NWW Var :=
SUMX (
VALUES ( DIM_Time[Calendar Month] ),
SUMX (
VALUES ( fact_result[project_code] ),
IF (
CALCULATE ( COUNTROWS ( fact_result ) ) > 0
&& CALCULATE (
COUNTROWS ( fact_result ),
PARALLELPERIOD ( DIM_Time[Date], -1, MONTH )
) > 0,
CALCULATE ( SUM ( fact_result[EAC_Fees] ) )
- CALCULATE (
SUM ( fact_result[EAC_Fees] ),
PARALLELPERIOD ( DIM_Time[Date], -1, MONTH )
),
0
)
)
)
similary you can also derive the formula for calcualting new work won from new projects...
Subscribe to:
Post Comments (Atom)
Elevating LLM Deployment with FastAPI and React: A Step-By-Step Guide
In a previous exploration , I delved into creating a Retrieval-Augmented-Generation (RAG) demo, utilising Google’s gemma model, Hugging ...
-
Error 15401: Windows NT user or group '%s' not found. Check the name again. SELECT name FROM syslogins WHERE sid = SUSER_SID ('Y...
-
start /wait D:\Servers\setup.exe /qn VS=[VIRTUALSERVER] INSTANCENAME=[MSSQLSERVER] REINSTALL=SQL_Engine REBUILDDATABASE=1 ADMINPASSWORD=[CUR...
-
Finally, it is time. E4SE 811 and eBackoffice 736 will replace our current 810b/735a environment after staying so many years. Just got the n...
No comments:
Post a Comment