PLEASE HELP - Formula Bar

[Anonymous]

Hi, 

Is there any reason that formula bar only displays some tables  when you try to create things ?  In other words, formula bar says " Can not find name ", I typed it correctly and I still can not understand why. Please help me if you have any answer. 

Thank you, 

Yavuz 

[Anonymous]

Hi @Anonymous ,

The DATEDIFF function returns the count of interval boundaries crossed between two dates.

Syntax

DATEDIFF(<start_date>, <end_date>, <interval>)  

For example, DATEDIFF(MIN( Calendar[Date] ), MAX( Calendar[Date]), SECOND ) will return seconds.

The formula you provided doesn't seem right.

It would be nice if you could provide some dummy data and expected results.

Best Regards,

Stephen Tao

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

[amitchandak]

@Anonymous , It that is measure and you are creating a measure start with [I . If you are not sure the start with I

If this column and you are creating a measure start with count( I  // some aggregate

or with table name

[Anonymous]

@amitchandak thank you for replying.   Now, also issue is here it says too many argument and I do not know how I can do.  

This measure formula is great and working. But you can it covers only 1 table and it is good for my first page. 

2hours =

var _diff=DATEDIFF(MAX(Tab_ImagerOperation[EndTimeET]),NOW(),HOUR)

return IF(_diff<=2&&_diff>=0,1)

Now, I have to create for the second page with the same measure but this time multiple tables and it says took many argument. Where do I make mistake ? THank you

_2hours =

var _diff=DATEDIFF(MAX('Tab_ImagerOperation'[EndTimeET]), COUNT(Tab_WFSEventLog[EventTimeET]), NOW(),HOUR)

return IF(_diff<=2&&_diff>=0,1)