Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Difference with Measure and column Dax calculations

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(Tod...
calculated column
measure
  • Anonymous's avatar
    Anonymous
    4 years ago

    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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , I am getting 28th for both

measure

 

 

 

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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: