topic Re: DateDiff in DAX Commands and Tips

DateDiff

Anonymous — Thu, 28 Oct 2021 14:32:57 GMT

Bom dia a comunidade...

Preciso de ajuda quanto ao relatório que estraí utilizando o comando DateDiff.

O que devo fazer para somar os total dos dias por área ?

Não entendo o resultado negativo em -83 dias.

Formula utilizada.

DIAS PARADOS =

IF(ISBLANK(Max(SUSE[Data/Hora Conclusão da atividade])),

DATEDIFF(Max(SUSE[Data/Hora Início da atividade]),TODAY(),DAY),

DATEDIFF(MAX(SUSE[Data/Hora Início da atividade]), MAX(SUSE[Data/Hora Conclusão da atividade]),DAY))

Agradeço a ajuda.

Re: DateDiff

lbendlin — Sat, 30 Oct 2021 00:48:38 GMT

What is your expected result? Think like the Grand Total. Very often measures designed for the Grand Total will also work for the Row and Column Totals and for the individual cells.

Re: DateDiff

v-cazheng-msft — Mon, 01 Nov 2021 01:21:03 GMT

Hi Anonymous

When a Measure is used on rows in a table, the column total for those rows is not calculated as a sum of the results in the rows, but instead it calculates using the same Measure formula and applies it to the total of the data selected. Due to this feature, the total value may be unexpected. In such case, you may do further calculation and correct the total value. Please try the Measure below and use it to create your visual instead of using DIAS PARADOS.

Correct_total = SUMX (

SUMMARIZE(SUSE,SUSE[Data/Hora Conclusão da atividade]),

SUSE[DIAS PARADOS]

)

Then, the result will look like this:

Best Regards,

Community Support Team _ Caiyun

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.