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.
Resulta que debo realizar un conteo de incidentes de un mismo usuario dentro de un mismo mes, necesito saber cuanto incidentes realiza a soporte un mismo usuario, he intentado de muchas maneras pero no consigo el resultado.
Estoy tratando de utilizar el sigiente Dax pero no funciona, soy relativamente nuevo en este mundo.
PedidosEnMesSeleccionado =
VAR CurrentFirstOrderDate = SELECTEDVALUE('Data'[First Order Date (EOM)])
VAR MonthsAfter = SELECTEDVALUE('Months After'[Value])
VAR SelectedMonth = EOMONTH(CurrentFirstOrderDate,MonthsAfter)
RETURN
CALCULATE(
COUNTROWS('Data'),
FILTER(
'Data',
'Data'[Customer ID] = SELECTEDVALUE('Data'[Customer ID]) &&
EOMONTH('Data'[Order Date],0) = SelectedMonth
)
)
Solved! Go to Solution.
Hi @manuel_yhvh
Depending on your description, you may want to consider, for example, whether you have a corresponding date in your corresponding data table after setting the Months After' [Value] setting, for example, the maximum date in your data table is 2023/5/1 But the date you filter may be more than 5/1/2023, so a null value may be returned.
If the above suggestions did not help you, can you provide some pictures of the results you expect or pictures of the current error?
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @manuel_yhvh
Depending on your description, you may want to consider, for example, whether you have a corresponding date in your corresponding data table after setting the Months After' [Value] setting, for example, the maximum date in your data table is 2023/5/1 But the date you filter may be more than 5/1/2023, so a null value may be returned.
If the above suggestions did not help you, can you provide some pictures of the results you expect or pictures of the current error?
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
15 | |
8 | |
6 | |
6 | |
6 |
User | Count |
---|---|
23 | |
14 | |
13 | |
8 | |
8 |