Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Stefanve
Frequent Visitor

Accentuating a period that is longer than 10 days and higher than 15 degrees

Hi,

 

In the scenario below i have a date and temperature column.

What we are trying to visualize is accentuating a period that is longer than 10 days and higher than 15 degrees. Like the Excel example below.

 

Who can help me visualise this?

 

Stefanve_0-1634895449853.png

Thanks,

 

Stefan

1 ACCEPTED SOLUTION
ikor42
Regular Visitor

Hi,
try this measure:

Temperature_15_and_higher =
VAR _cur_date = SELECTEDVALUE ( Temp[Date] )
VAR _first_date_before_below_15 =
MAXX (
FILTER (
ALL ( Temp ),
Temp[Date] <= _cur_date &&
Temp[Date] >= _cur_date - 9 &&
Temp[Temprature] < 15
),
Temp[Date]
)
VAR _first_date_after_below_15 =
MINX (
FILTER (
ALL ( Temp ),
Temp[Date] >= _cur_date &&
Temp[Date] <= _cur_date + 9 &&
Temp[Temprature] < 15
),
Temp[Date]
)
VAR _number_of_days =
IF ( ISBLANK ( _first_date_before_below_15 ), 10, INT(_cur_date - _first_date_before_below_15) ) +
IF ( ISBLANK ( _first_date_after_below_15 ), 10, INT(_first_date_after_below_15 - _cur_date) ) -
1
RETURN
IF ( _number_of_days >= 10, SELECTEDVALUE(Temp[Temprature]), BLANK() )
 


We can put this measure along with Temprature field on the visual. The result is next:

ikor42_0-1634908600659.png

 

 

View solution in original post

1 REPLY 1
ikor42
Regular Visitor

Hi,
try this measure:

Temperature_15_and_higher =
VAR _cur_date = SELECTEDVALUE ( Temp[Date] )
VAR _first_date_before_below_15 =
MAXX (
FILTER (
ALL ( Temp ),
Temp[Date] <= _cur_date &&
Temp[Date] >= _cur_date - 9 &&
Temp[Temprature] < 15
),
Temp[Date]
)
VAR _first_date_after_below_15 =
MINX (
FILTER (
ALL ( Temp ),
Temp[Date] >= _cur_date &&
Temp[Date] <= _cur_date + 9 &&
Temp[Temprature] < 15
),
Temp[Date]
)
VAR _number_of_days =
IF ( ISBLANK ( _first_date_before_below_15 ), 10, INT(_cur_date - _first_date_before_below_15) ) +
IF ( ISBLANK ( _first_date_after_below_15 ), 10, INT(_first_date_after_below_15 - _cur_date) ) -
1
RETURN
IF ( _number_of_days >= 10, SELECTEDVALUE(Temp[Temprature]), BLANK() )
 


We can put this measure along with Temprature field on the visual. The result is next:

ikor42_0-1634908600659.png

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.