Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Solved! Go to Solution.
Hi @Anonymous ,
One sample for your reference.
DURATION = DATEDIFF ( MAX ( 'Table'[sai_startdate] ), MAX ( 'Table'[sai_duedate] ), DAY )
If this is a measure, you need to give it some type of context. Right now, you are reffering to a whole column, so it does not know which value in the column to use.
If you plan on using this in a table or graph, using the function "Selectedvalue" will add the current context.
Try this:
DURATION = DATEDIFF( SELECTEDVALUE(sai_duedate) , SELECTEDVALUE(sai_startdate) , day )
Did I answer your question? Mark my post as a solution! Proud to be a Super User!
Connect with me!
Stay up to date on
Read my blogs on
Thanks Steve , I want to apply it on row level . Will this work ?
Hi @Anonymous ,
One sample for your reference.
DURATION = DATEDIFF ( MAX ( 'Table'[sai_startdate] ), MAX ( 'Table'[sai_duedate] ), DAY )
User | Count |
---|---|
9 | |
9 | |
7 | |
6 | |
6 |