Forum Discussion
TRICKY max date - Calculated column measure
Hi Experts
See expected result in the table below with light blue header. Need a cacalated column measure to give the max ACTDate if all the Child TaskID and WorkORder ID's have a date. If they have no ACTDate as shown in the first image then return back no max date..
Anonymous , A new column like
if([POC] ="Parent" , blank(), maxx(filter(Table, [TAsk id] =earlier([Task id]) && [Workitem id] =earlier([Workitem id]) ), [Act Date])
7 Replies
- amitchandak
Super User
Anonymous , A new column like
if([POC] ="Parent" , blank(), maxx(filter(Table, [TAsk id] =earlier([Task id]) && [Workitem id] =earlier([Workitem id]) ), [Act Date])
hi Amit - new question where your column measure need tweeking
- ChrisMendoza
Resident Rockstar
Anonymous - You have the same issue as your last post; the variant data type:
posted a correction to the question in a new question as no one else got this
https://community.powerbi.com/t5/Desktop/Modify-current-DAX-Measure/m-p/3041067#M1034597
