Forum Discussion
DAX Expression to implement in Power BI to replicate with tableau Expression
Can someone help me to implement the same syntax from Tableau into Power BI
C_Suspense =
IF [Date] = {FIXED: Max(IIF([Suspense] > 0, [Date], Date('01/01/2021')))}
THEN [Suspense]
ELSE 0
END
please help with new column or new measure
Hi, Anonymous ;
You could create a measure.
Measure = CALCULATE(SUM('Table'[suspense ($)]),FILTER('Table',[Date]=CALCULATE(MAX('Table'[Date]),ALL('Table'))))The final show:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
v-yalanwu-msftCommunity Support
Hi, Anonymous ;
You could create a measure.
Measure = CALCULATE(SUM('Table'[suspense ($)]),FILTER('Table',[Date]=CALCULATE(MAX('Table'[Date]),ALL('Table'))))The final show:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.- SpartaBI
Community Champion
Anonymous better if you can share a sample data and the desired result and I could write to you the code.
