Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello dear community
I can't get out of a worry.
I can express it, but I can't put it into words.
Here you have an exel chart.
On the left you have a small sample of data and on the right the expected result.
I have several of the same file numbers for different tasks.
The start date must always be the date corresponding to name, which contains AB.
The end date is a little more complex. I take the oldest date of the lines only if each line has the status TRUE if a line doesn't have the status True then it's empty.
Any ideas?
Thank you very much in advance
Solved! Go to Solution.
hello @MiloDi
output
measure 1 -- start date
Start Date =
var start_date =
FILTER(
Tableau1,
Tableau1[Name] = "AB"
)
return
MINX(start_date,Tableau1[Date])
measure 2 -- end date
End Date =
var count_all = COUNTROWS(Tableau1)
var end_true =
FILTER(
Tableau1,
Tableau1[Status] = TRUE()
)
var count_true = COUNTROWS(end_true)
var res =
SWITCH(
TRUE(),
count_all <> count_true , blank(),
MAXX(end_true,[Date])
)
return res
let me know if this works for you .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
modify the code to this :
End Date =
var count_all = calculate(COUNTROWS(Tableau1) , REMOVEFILTERS(Tableau1[Status]))
var end_true =
FILTER(
Tableau1,
Tableau1[Status] = TRUE()
)
var count_true = COUNTROWS(end_true)
var res =
SWITCH(
TRUE(),
count_all <> count_true , blank(),
MAXX(end_true,[Date])
)
return res
let me know if this helps ....
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
hello @MiloDi
output
measure 1 -- start date
Start Date =
var start_date =
FILTER(
Tableau1,
Tableau1[Name] = "AB"
)
return
MINX(start_date,Tableau1[Date])
measure 2 -- end date
End Date =
var count_all = COUNTROWS(Tableau1)
var end_true =
FILTER(
Tableau1,
Tableau1[Status] = TRUE()
)
var count_true = COUNTROWS(end_true)
var res =
SWITCH(
TRUE(),
count_all <> count_true , blank(),
MAXX(end_true,[Date])
)
return res
let me know if this works for you .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
Good afternoon, Daniel29195,
First thank you for your time and your answer.
In my case its not working properly , I have date for Id who have one false statut.
I join you the PBI, perhaps I do soemthing wrong.
Can you guide me ?
thank you in advance
modify the code to this :
End Date =
var count_all = calculate(COUNTROWS(Tableau1) , REMOVEFILTERS(Tableau1[Status]))
var end_true =
FILTER(
Tableau1,
Tableau1[Status] = TRUE()
)
var count_true = COUNTROWS(end_true)
var res =
SWITCH(
TRUE(),
count_all <> count_true , blank(),
MAXX(end_true,[Date])
)
return res
let me know if this helps ....
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
Hello @Daniel29195
Thank you very much for your time. Its working fine sir. It's amazing.
I understand your measure So I'm getting better at it too 😉
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
79 | |
63 | |
61 | |
59 |
User | Count |
---|---|
166 | |
114 | |
100 | |
73 | |
67 |