topic Re: IF and TIME function in DAX Commands and Tips

IF and TIME function

am_i_really — Tue, 07 Feb 2023 18:51:49 GMT

Hi All,

I'm looking for a if and time dax statement that gives me the total count of rows in Table[Order Time] that are less than 10am as "breakfast" and greater than 10 as "Lunch".

Thank you in advance!

Re: IF and TIME function

Greg_Deckler — Tue, 07 Feb 2023 18:56:17 GMT

am_i_really Try:

Breakfast = VAR __Table = ADDCOLUMNS('Table',"__Hour",HOUR([Order Time])) VAR __Result = COUNTROWS(FILTER(__Table,[__Hour] < 10)) RETURN __Result Lunch = VAR __Table = ADDCOLUMNS('Table',"__Hour",HOUR([Order Time])) VAR __Result = COUNTROWS(FILTER(__Table,[__Hour] >= 10)) RETURN __Result

Re: IF and TIME function

smpa01 — Tue, 07 Feb 2023 19:07:28 GMT

am_i_really

breakfast = CALCULATE ( COUNTROWS ( 'fact' ), FILTER ( 'fact', TIMEVALUE ( CALCULATE ( MAX ( 'fact'[Value] ) ) ) <= TIME ( 10, 00, 00 ) ) ) lunch = CALCULATE ( COUNTROWS ( 'fact' ), FILTER ( 'fact', TIMEVALUE ( CALCULATE ( MAX ( 'fact'[Value] ) ) ) > TIME ( 10, 00, 00 ) ) )