Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
i have an alert table linked to an association table that contains a status for each alert and finally an status table containing the status name.
the dataset can be found here
and the data model here
what i want is a matrix showing the number of alerts and the increase/decrease poucentage per status and per month
for that i created two measures. The first is a simple count :
Solved! Go to Solution.
Hi @wahib_mouhoubi ,
This issue is caused by the time intelligence function.The date of the actual data cannot match the date in the time intelligence function.
Try to add a filter condition in measure:
evolution = IF(MAX(dates[Date]) in VALUES(ALERTS[CREATION_DATE]),
DIVIDE([nbr-alertes],
CALCULATE([nbr-alertes],DATEADD(dates[Date],-1,MONTH)),0) -1)
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @wahib_mouhoubi ,
This issue is caused by the time intelligence function.The date of the actual data cannot match the date in the time intelligence function.
Try to add a filter condition in measure:
evolution = IF(MAX(dates[Date]) in VALUES(ALERTS[CREATION_DATE]),
DIVIDE([nbr-alertes],
CALCULATE([nbr-alertes],DATEADD(dates[Date],-1,MONTH)),0) -1)
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi again @V-lianl-msft ,
I reversed the condition
evolution = IF(MAX(ALERTS[CREATION_DATE]) in VALUES(dates[Date]),
DIVIDE([nbr-alertes],
CALCULATE([nbr-alertes],DATEADD(dates[Date],-1,MONTH)),0) -1)
and it works perfectly !
thank you !
Hi @V-lianl-msft ,
First, thank you for your reply, it seem to work but, if i understood well, it calculates the pourcentage only if the the last date of each month is present in the alerts table, which is not necessarely the case in my real dataset, producing gaps in the pourcentage report (i've tried
evolution = IF(MAX(dates[Date]) in VALUES(ALERTS[CREATION_DATE]) ||
MIN(dates[Date]) in VALUES(ALERTS[CREATION_DATE]),
....
but i still have gaps.
Any idea please?
Thank you.
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |