The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi Guys!
I need your help!
Could you help me with a DAX mesure wicth can help me to have the status colomn based on stard and end date.
Please the screen below:
Thank you for your help
Solved! Go to Solution.
@dofrancis3 Maybe:
Measure =
VAR __Today = TODAY()
VAR __Start = MAX( 'Table'[Started] )
VAR __End = MAX( 'Table'[end_date] )
VAR __Result =
SWITCH( TRUE(),
__Start > __Today, "Upcoming",
__End < __Today, "Completed",
"Ongoing"
)
RETURN
__Result
Column =
VAR __Today = TODAY()
VAR __Start = [Started]
VAR __End = [end_date]
VAR __Result =
SWITCH( TRUE(),
__Start > __Today, "Upcoming",
__End < __Today, "Completed",
"Ongoing"
)
RETURN
__Result
@dofrancis3 Maybe:
Measure =
VAR __Today = TODAY()
VAR __Start = MAX( 'Table'[Started] )
VAR __End = MAX( 'Table'[end_date] )
VAR __Result =
SWITCH( TRUE(),
__Start > __Today, "Upcoming",
__End < __Today, "Completed",
"Ongoing"
)
RETURN
__Result
Column =
VAR __Today = TODAY()
VAR __Start = [Started]
VAR __End = [end_date]
VAR __Result =
SWITCH( TRUE(),
__Start > __Today, "Upcoming",
__End < __Today, "Completed",
"Ongoing"
)
RETURN
__Result
User | Count |
---|---|
16 | |
8 | |
6 | |
6 | |
5 |
User | Count |
---|---|
23 | |
13 | |
13 | |
8 | |
8 |