The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
null
Hi,
I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.
Expected measure: =
VAR _newtable =
ADDCOLUMNS (
Data,
"@HC", CALCULATE ( SUM ( Data[Ending HC] ) ),
"@HCprevmonth",
CALCULATE (
SUM ( Data[Ending HC] ),
FILTER (
ALL ( Data ),
Data[Fiscal Month ID]
= EARLIER ( Data[Fiscal Month ID] ) - 1
)
)
)
VAR _monthcount =
COUNTROWS ( Data )
RETURN
DIVIDE ( SUMX ( _newtable, [@HC] + [@HCprevmonth] ), _monthcount * 2 )
Do you have an alternative to the earlier function as that does not work
Hi,
Please try the below, and check the attached file.
Expected measure V2: =
VAR _newtable =
ADDCOLUMNS (
Data,
"@HC", CALCULATE ( SUM ( Data[Ending HC] ) ),
"@HCprevmonth",
CALCULATE (
SUMX (
FILTER (
ALL ( Data ),
Data[Fiscal Month ID]
= MAX ( Data[Fiscal Month ID] ) - 1
),
Data[Ending HC]
)
)
)
VAR _monthcount =
COUNTROWS ( Data )
RETURN
DIVIDE ( SUMX ( _newtable, [@HC] + [@HCprevmonth] ), _monthcount * 2 )
It works in the pbix file but getting odd results in my measure
Hi,
Please share your sample pbix file's link.
Thanks.
User | Count |
---|---|
74 | |
70 | |
39 | |
30 | |
28 |
User | Count |
---|---|
104 | |
95 | |
51 | |
48 | |
46 |