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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Outdated product - DAX Measure

Hello, 

Basic information: 

dgadzinski_2-1670272967286.png

In "Green" calculation we had the change and it means: All Product > TODAY

 

I have an issue with measure because the measure is counting values incorrectly. I would like the measure to also take into account the individual days of the month but for rest days of December it doesn't display values: 

dgadzinski_0-1670272759947.png

How to change the calculation in this measure? 

 

dgadzinski_1-1670272810511.png

This is pbix file with my calculations: 

https://uewrc-my.sharepoint.com/:u:/g/personal/170361_student_ue_wroc_pl/EZopWei7GwFHjmyczp3DqQMBtpp...

 

Could you help me, please? 

 

1 ACCEPTED SOLUTION
sevenhills
Super User
Super User

I think your calculation does not consider "diff = 0" scenario. See if the below works:

 

Measure 2 = 
var cur_yearly_review=SELECTEDVALUE('Table'[Yearly review])
var cur_date=TODAY()
var diff=DATEDIFF(cur_yearly_review,cur_date,MONTH)
-- return diff
return 
SWITCH(TRUE(),
       diff > 6, "More than 6 months",
       diff >= 0, "Less than 6 months",
       diff < 0, "All recertified")

 

sevenhills_0-1670368896931.png

 

View solution in original post

1 REPLY 1
sevenhills
Super User
Super User

I think your calculation does not consider "diff = 0" scenario. See if the below works:

 

Measure 2 = 
var cur_yearly_review=SELECTEDVALUE('Table'[Yearly review])
var cur_date=TODAY()
var diff=DATEDIFF(cur_yearly_review,cur_date,MONTH)
-- return diff
return 
SWITCH(TRUE(),
       diff > 6, "More than 6 months",
       diff >= 0, "Less than 6 months",
       diff < 0, "All recertified")

 

sevenhills_0-1670368896931.png

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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