topic Re: Need help DAX in DAX Commands and Tips

Need help DAX

Nihed — Tue, 21 Dec 2021 22:29:21 GMT

Hello,

How I can convert this formula into dax please :

IF 'PPM'[Step] = "9-Finalised" then STEP DURATION = SUM(each STEP DURATION from TORs to Signature)

(what is the correct syntax for each)

Thank you.

Re: Need help DAX

VahidDM — Tue, 21 Dec 2021 22:32:53 GMT

Hi Nihed

It'd be better if you share a sample of your data to know the column name and data type.

BTW, you need to use a dax like this:

IF(MAX('PPM'[Step])="9-Finalised",SUM(each STEP DURATION from TORs to Signature))

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

Re: Need help DAX

Nihed — Tue, 21 Dec 2021 22:51:42 GMT

Bonjour

Je partage avec vous le lien de mon exemple dans pbix : https://we.tl/t-PjRN81lAWA

et mon but est de calculer le KPI dans le tableau ci-dessous (DURÉE DE L’ÉTAPE) à partir des deux tableaux quelqu’un m’a aidé un peu sur ce sujet s’il vous plaît

Re: Need help DAX

V-lianl-msft — Fri, 24 Dec 2021 07:05:29 GMT

Hi Nihed ,

It's hard to understand the calculation logic of "8-xxx"&"9-xxx". In the sample pbix you provided, I can't create the corresponding calculation.

Measure = var current_step = MAX(PPM[Steps]) return SWITCH(TRUE(), current_step = "1 - Planned/Not Started",0, current_step="2 - TORs received/under review",AVERAGEX(PPM,PPM[TORs completed]-PPM[TORs received]), current_step="3 - Open for Competition", AVERAGEX(PPM,PPM[Closes on]-PPM[Posted on]), current_step="4 - Technical Evaluations", AVERAGEX(PPM,PPM[Technical evaluation completed]-PPM[Closes on]), current_step = "5 - Financial Negotiations", AVERAGEX(PPM,PPM[Negotiation completed]-PPM[Technical evaluation completed]), current_step="6 - Procurement Board", AVERAGEX(PPM,PPM[PB date]-PPM[Negotiation completed]), current_step = "7 - Legal Review", AVERAGEX(PPM,PPM[Reviewed by LEG]-PPM[PB date]), current_step="8 - Signature", AVERAGEX( ))

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