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.
Hi, I need to find the Events Delta (Delta Column in picture below) from the last 8 days, based on my measure calculation created for # of Events and Create Date Difference expression, which calculates the difference in days between my create date and today.
Example of wanted outcome:
Current Errored Delta Forumla:
Thank you in advance for your help!
Solved! Go to Solution.
Hi @Coffee2023 ,
Unable to see the details of your error .
I assumed some data:
Use the following DAX expression to create a measure
Delta =
VAR _result = COUNTROWS(FILTER('vw_table','vw_table'[COTypeName] = "Event" && 'vw_table'[Create Date Difference] < 8))
RETURN IF(ISBLANK(_result),0,_result)
Final output
Best Regards,
Wenbin Zhou
Hi @Coffee2023 ,
Unable to see the details of your error .
I assumed some data:
Use the following DAX expression to create a measure
Delta =
VAR _result = COUNTROWS(FILTER('vw_table','vw_table'[COTypeName] = "Event" && 'vw_table'[Create Date Difference] < 8))
RETURN IF(ISBLANK(_result),0,_result)
Final output
Best Regards,
Wenbin Zhou
User | Count |
---|---|
27 | |
12 | |
8 | |
8 | |
5 |
User | Count |
---|---|
31 | |
15 | |
12 | |
7 | |
6 |