Forum Discussion

ohnothimagain's avatar
ohnothimagain
Helper I
1 year ago

[Basic] userelationship on variable table #2

Hello everyone : ) It's might be a basic but I've been stucking for weeks,hope anyone could tell me..   ■trying to do want to calculate schedule fluctuation count. summarize a table for exculdin...
BeaBF's avatar
BeaBF
Super User
1 year ago

ohnothimagain Try with:

 

test11 :=
VAR _tbl =
SUMMARIZE(
'TEST_',
'TEST_'[PN],
'TEST_'[PO],
'TEST_'[M_Date],
'TEST_'[R_Date]
)
VAR _result =
CALCULATE(
COUNTROWS(_tbl),
'TEST_'[M_Date] < 'TEST_'[R_Date], 
USERELATIONSHIP('Calendar'[Date], 'TEST_'[R_Date]) 
)
RETURN
_result

 

BBF

  • ohnothimagain's avatar
    ohnothimagain
    Helper I
    1 year ago

    Thank you for your quick responding!
    I tried but unfortunately it was unsuccess(same result).