Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hi all,
I have a table with employee, exam, date of exam and type of exam.
I need to program the next exam for each employer. Each employer has to do a new exam past 1 year of the last.
So, I use the data of exam and sum 12 moths to get a new data. Like exemple below:
emplyer | date of exam | type | next exam |
Leonardo | 05/04/2024 | blood | 05/04/2025 |
Rafael | 05/04/2022 | blood | 05/04/2023 |
Rafael | 05/04/2023 | blood | 04/04/2024 |
Rafael | 05/04/2024 | blood | 05/04/2025 |
My trouble is: I need the calculate the next Rafael's exam only based the last date.
The correct result is:
employee | date of exam | type | next exam |
Leonardo | 05/04/2024 | blood | 05/04/2025 |
Rafael | 05/04/2022 | blood | |
Rafael | 05/04/2023 | blood | |
Rafael | 05/04/2024 | blood | 05/04/2025 |
How can I do it on Power BI?
Sorry any mistake, I'm Brazilian and still learning english.
Solved! Go to Solution.
Expertise = List.Accumulate( {Days as from Today}, {Skills and Knowledge}, (Current, Everyday) => Current & Day.LearnAndPractise(Everyday) ) |
I tried that solucion and worked!
I dont know many dax that you use, like: INDEX, EDATE...
I will continue studying and practing. Thank you so much, you save me!
Hi @LeonardCs
You may try the following calculated column
next exam =
IF (
'Table'[date of exam]
= CALCULATE (
MAX ( 'Table'[date of exam] ),
ALLEXCEPT ( 'Table', 'Table'[employee], 'Table'[type] )
),
EDATE ( 'Table'[date of exam], 12 )
)
Hey, thank you so much for answer me
User | Count |
---|---|
12 | |
12 | |
8 | |
8 | |
6 |
User | Count |
---|---|
27 | |
19 | |
14 | |
11 | |
7 |