topic Difference with Measure and column Dax calculations in DAX Commands and Tips

Difference with Measure and column Dax calculations

garyhumphreys — Mon, 30 May 2022 09:42:37 GMT

Hi,

I hope this hasn't already been asked - I did look for it but couldn't find anything

I have a measure and a calculated column, both have the formula: "LastFriday = Today() - Weekday(Today(),1)"

However they return different values. as of today of testing (30/05/2022),

The measure returns 27/05/22 , which is the date I want

The Column returns 28/05/22 Which is annoying.

Is this a known issue? or am I misunderstanding something?

Thanks in advance for any help on this matter

Re: Difference with Measure and column Dax calculations

amitchandak — Mon, 30 May 2022 11:35:44 GMT

garyhumphreys , I am getting 28th for both

measure

Re: Difference with Measure and column Dax calculations

garyhumphreys — Mon, 30 May 2022 12:27:24 GMT

Hi amitchandak

Thanks for your response, Im not exactly sure why mine is showing as it does, when I use the Formula in a measure it gives me a Time value of 23:00. I'm sure this is why I'm getting a different date but I'm unsure as to what is controling this seeing as I use the same formula.

As a column:

As a measure:

Re: Difference with Measure and column Dax calculations

Whitewater100 — Mon, 30 May 2022 12:57:41 GMT

Hi:

Could it be that you need to have yourDate Table marked as date table? Please see attached model set up and comparisons?

https://drive.google.com/file/d/1FHi3tAapY2C4kVb_hc25oreQmUnFi27m/view?usp=sharing

Re: Difference with Measure and column Dax calculations

garyhumphreys — Mon, 30 May 2022 14:21:56 GMT

Whitewater100 , amitchandak

Thank you both for your replies, after knowing which date others got it helped me narrow down the problem.

When I viewed my Visual in "Visual Table" It showed as the 28th, but the display was wrong. (image 1). So i displayed the date on a Card Visual and it shows the 28th!

The Enlighten Data Story Visual I am using is what was causing the display error giving me the 27th! (image2)

Thank you both for the help on this!

Image 1

Image 2