Forum Discussion

Fsciencetech's avatar
Fsciencetech
Icon for Helper III rankHelper III
5 years ago
Solved

Dax formula not working

Hi folks,   Need your help, I don't want to sum to [SupplierPOCreated], Only need to subtract, how do modify below dax. Material Age = CALCULATE( DATEDIFF( MAX( OSMSData[OSLastReplanDate].[D...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

    Hi Fsciencetech ,

     

    Or try this formula.

    Material Age = 
CALCULATE(
DATEDIFF(
    MAX( OSMSData[OSLastReplanDate].[Date] ),
    MAX( OBFact_Current[SupplierPOCreated].[Date] ),
    DAY
),
FILTER(
    OBFact_Current,OBFact_Current[FutureCrdFlag] = "N" && OBFact_Current[SupplierPOCreated].[Date] <> BLANK()
    )
)

     

    Best regards,
    Lionel Chen

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

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Fsciencetech , Try like

 

CALCULATE(
DATEDIFF(
MAX(
OSMSData[OSLastReplanDate].[Date]
),
MAXX(OBFact_Current,OBFact_Current[SupplierPOCreated].[Date]),DAY),
FILTER(
OBFact_Current,OBFact_Current[FutureCrdFlag] = "N" && not(isblank(OBFact_Current[SupplierPOCreated] ))
) )

 

do not .date if there is not timestamp

 

also refer my blog on date diff

https://community.powerbi.com/t5/Community-Blog/Decoding-Direct-Query-in-Power-BI-Part-2-Date-Difference-Across/ba-p/934397#M451

  • Fsciencetech's avatar
    Fsciencetech
    Icon for Helper III rankHelper III
    5 years ago

    Thanks Amit, Let me check your dax result.

    • v-lionel-msft's avatar
      v-lionel-msft
      Icon for Community Support rankCommunity Support
      5 years ago

      Hi Fsciencetech ,

       

      Or try this formula.

      Material Age = 
CALCULATE(
DATEDIFF(
    MAX( OSMSData[OSLastReplanDate].[Date] ),
    MAX( OBFact_Current[SupplierPOCreated].[Date] ),
    DAY
),
FILTER(
    OBFact_Current,OBFact_Current[FutureCrdFlag] = "N" && OBFact_Current[SupplierPOCreated].[Date] <> BLANK()
    )
)

       

      Best regards,
      Lionel Chen

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