Forum Discussion
PLEASE HELP - Formula Bar
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
3 Replies
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
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)
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.
