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
dgadzinski
Helper I
Helper I

Issue with DAX Measure - Date

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

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

 

Could you help me, please? 

 

3 REPLIES 3
mangaus1111
Solution Sage
Solution Sage

Hi @dgadzinski ,

what about this measure?

SWITCH(TRUE(),
diff>0&&ABS(diff)<=6,"Less than 6 months",
diff>0&&ABS(diff)>6,"More than 6 months",
"All recertified"
)

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-jayw-msft
Community Support
Community Support

Hi @dgadzinski ,

 

Please share some sample data in text format so that we could test the formula.

 

 

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

I attached pbix file.

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.