Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi all. I'm new in PowerBI, so apologies in advance for the very simple question.
I would like to create a measure that contains the value of Date modified row for Test Run Export XRay.csv file name (see image). In the example below the value I should be getting is: "20/08/2024 18:25:30".
What I need to include in my measure?
Thank you so much in advance!
Solved! Go to Solution.
Hi,ryan_mayu ,thanks for your concern about this issue.
Your answer is excellent!
And I would like to share some additional solutions below.
Hello,@TesterPowerBI .I am glad to help you.
In addition to using the iterative function maxx, you can use the IF judgment or calculate the target value by using the calculate function in conjunction with the max function to achieve your needs.
measure:
M_1 =
VAR _name=MAX('Table'[Name])
VAR _Extension=MAX('Table'[Extension])
VAR _modified=MAX('Table'[Date modified])
RETURN
CALCULATE(MAX('Table'[Date modified]),FILTER(ALL('Table'),CONTAINSSTRING(_name,"Test Run Support XRay.csv")))
measure:
M_2 =
VAR _name=MAX('Table'[Name])
VAR _Extension=MAX('Table'[Extension])
VAR _modified=MAX('Table'[Date modified])
RETURN
IF(CONTAINSSTRING(_name,"Test Run Support XRay.csv"),_modified)
Below is my test data:
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,ryan_mayu ,thanks for your concern about this issue.
Your answer is excellent!
And I would like to share some additional solutions below.
Hello,@TesterPowerBI .I am glad to help you.
In addition to using the iterative function maxx, you can use the IF judgment or calculate the target value by using the calculate function in conjunction with the max function to achieve your needs.
measure:
M_1 =
VAR _name=MAX('Table'[Name])
VAR _Extension=MAX('Table'[Extension])
VAR _modified=MAX('Table'[Date modified])
RETURN
CALCULATE(MAX('Table'[Date modified]),FILTER(ALL('Table'),CONTAINSSTRING(_name,"Test Run Support XRay.csv")))
measure:
M_2 =
VAR _name=MAX('Table'[Name])
VAR _Extension=MAX('Table'[Extension])
VAR _modified=MAX('Table'[Date modified])
RETURN
IF(CONTAINSSTRING(_name,"Test Run Support XRay.csv"),_modified)
Below is my test data:
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the very detailed explanation! It worked.
you can try this
Proud to be a Super User!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
75 | |
63 | |
52 | |
47 |
User | Count |
---|---|
218 | |
86 | |
64 | |
63 | |
60 |