Dax measure to show value of yesterday's

[koray]

Hello,

I think i have a simple question.

The measure I want to write is to bring the number in the Work Days column in the table below according to yesterday.
I can do this with filter, but I need the dax code because I will use the result later in the divide process.

Since today is May 27, result should be I want to get is 14.

Thank you for help.

[Jihwan_Kim · Accepted solution]

Hi, @koray 

Thank you for your feedback.

Do you want to see only yesterday's value in a card visualization?

Please check the below.

Work days Yesterday's value =

CALCULATE( [Work days Current], 'Table'[Date] = TODAY()-1)

https://www.dropbox.com/s/ok18yfwsmn6hznq/koray.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

[Jihwan_Kim]

Hi @koray 

Please check the below picture and the sample pbix file's link down below.

Work days previous date =

CALCULATE( [Work days Current], DATEADD( 'Table'[Date], -1,DAY))

https://www.dropbox.com/s/ok18yfwsmn6hznq/koray.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

[koray]

Hi @Jihwan_Kim 

Thank you for help.

It works correctly in the table display, but does not return the correct result in the card display. That's why I can't use this result in the next divide process.

[Jihwan_Kim · Accepted solution]

Hi, @koray 

Thank you for your feedback.

Do you want to see only yesterday's value in a card visualization?

Please check the below.

Work days Yesterday's value =

CALCULATE( [Work days Current], 'Table'[Date] = TODAY()-1)

https://www.dropbox.com/s/ok18yfwsmn6hznq/koray.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

[koray]

@Jihwan_Kim Can i ask one more question 😞

How can I show the highest number of work days for the current month on the card.

[Jihwan_Kim · Accepted solution]

Hi, @koray 

Thank you for your feedback.

Please check the link down below.

Highest Number for the current month =

VAR currentmonth =

EOMONTH ( TODAY (), 0 )

RETURN

MAXX (

FILTER ( ALL ( 'Table' ), EOMONTH ( 'Table'[Date], 0 ) = currentmonth ),

[Work days Current]

)

https://www.dropbox.com/s/ok18yfwsmn6hznq/koray.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

[koray]

This also worked 🙂 Thank you @Jihwan_Kim 

[koray]

It worked, thank you so much 🙂