topic Re: IF Time DAX Measure in DAX Commands and Tips

IF Time DAX Measure

am_i_really — Wed, 15 Feb 2023 17:02:18 GMT

Hi All,

I'm trying to write a DAX Measure to determine how many transactions are breakfast vs lunch. This is what I have but its not working. Any idea what I'm doing wrong?

IF(COUNT(Master[Order Time]) < TIME(11,00,00),"Breakfast", "Lunch")

For any orders before 11am, I need it to say Breakfast, and anything after 11am should be Lunch.

Thanks in advance!

Re: IF Time DAX Measure

Greg_Deckler — Wed, 15 Feb 2023 17:09:36 GMT

am_i_really Try below. However, this is very dependent on the format of your Order Time column, can you post an example of your data?

Measure Breakfast = VAR __Table = ADDCOLUMNS( 'Master', "__Type", IF([Order Time]) < TIME(11,00,00),"Breakfast", "Lunch") ) VAR __Result = COUNTROWS(FILTER(__Table, [__Type] = "Breakfast" RETURN __Result

Re: IF Time DAX Measure

am_i_really — Wed, 15 Feb 2023 17:28:25 GMT

Hi Greg_Deckler

This is what my column looks like. The solution you provided didnt work.

Re: IF Time DAX Measure

Greg_Deckler — Wed, 15 Feb 2023 19:15:42 GMT

am_i_really Sorry, I had some syntax errors in that, try this:

Measure Breakfast = VAR __Table = ADDCOLUMNS( 'Table', "__Type", IF([Order Time] < TIME(11,00,00),"Breakfast", "Lunch") ) VAR __Result = COUNTROWS(FILTER(__Table, [__Type] = "Breakfast")) RETURN __Result