Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
i want below result.
ID | Status | Result |
123 | Fullypaid | Fullypaid |
123 | 1 | Fullypaid |
123 | 2 | Fullypaid |
123 | 3 | Fullypaid |
124 | Fullypaid | Fullypaid |
124 | Fullypaid | Fullypaid |
124 | Fullypaid | Fullypaid |
125 | 1 | Non Fullypaid |
125 | 2 | Non Fullypaid |
125 | 3 | Non Fullypaid |
126 | 1 | Fullypaid |
126 | 2 | Fullypaid |
126 | Fullypaid | Fullypaid |
Solved! Go to Solution.
Hi,
Please check the below picture and the attached pbix file.
It is for creating a calculated column.
Result CC =
IF (
{ "Fullypaid" }
IN SUMMARIZE ( FILTER ( Data, Data[ID] = EARLIER ( Data[ID] ) ), Data[Status] ),
"Fullypaid",
"NON"
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
thank you much, resloved
hi @Ravinder1
you may also try like:
Column =
VAR _list =
CALCULATETABLE(
VALUES(data[Status]),
ALLEXCEPT(data, data[ID])
)
RETURN
IF(
"Fullypaid" IN _list,
"Fullypaid",
"Not Fullypaid"
)
or
Column2 =
VAR _list =
CALCULATETABLE(
VALUES(data[Status]),
data[ID]=EARLIER(data[ID])
)
RETURN
IF(
"Fullypaid" IN _list,
"Fullypaid",
"Not Fullypaid"
)
it worked like:
Thank you so much Sir
Simplest Excel formula is way more than enough to solve such a small question
=IF(COUNTIFS([ID];[@ID];[Status];"Fullypaid");"Fullypaid";"Non Fullypaid")
Expertise = List.Accumulate( {Days as from Today}, {Skills and Knowledge}, (Current, Everyday) => Current & Day.LeanAndPractise(Everyday) ) |
Hi,
Please check the below picture and the attached pbix file.
It is for creating a calculated column.
Result CC =
IF (
{ "Fullypaid" }
IN SUMMARIZE ( FILTER ( Data, Data[ID] = EARLIER ( Data[ID] ) ), Data[Status] ),
"Fullypaid",
"NON"
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.