HSBC PTP =
VAR _mkids =
CALCULATETABLE (
VALUES ( 'dev moment_keywords'[id] ),
FILTER ( 'dev moment_keywords', 'dev moment_keywords'[moment_id] = 418 )
)
VAR _tids =
CALCULATETABLE (
VALUES ( 'dev moment_mapping'[transcription_id] ),
FILTER ( 'dev moment_mapping', 'dev moment_mapping'[moment_keyword_id] IN _mkids )
)
VAR _aids =
CALCULATETABLE (
VALUES ( 'dev transcription'[audio_id] ),
FILTER ( 'dev transcription', 'dev transcription'[id] IN _tids )
)
RETURN
IF(ISBLANK(CALCULATE (
DISTINCTCOUNT ( 'dev audio'[id] ),
FILTER ( 'dev audio', 'dev audio'[id] IN _aids )
)),0,CALCULATE (
DISTINCTCOUNT ( 'dev audio'[id] ),
FILTER ( 'dev audio', 'dev audio'[id] IN _aids )
) )
This formula will give me count of a certain moment . I also have a date slicer using calltime (contains only dates) from dev audio table to filter values for last 30 days. I need to create a visual where I can see the count of the moment at the present as well as the count value from yesterday so I can check for growth or decay. Please help me modify this dax.
i have tried formulas like dateadd and today()-1 and the regular stuff but I am stuck , so kindly help me out if possible.
