Forum Discussion

am_i_really's avatar
am_i_really
Frequent Visitor
3 years ago
Solved

IF Time DAX Measure

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[O...
@Dax help
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    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
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

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

 

  • am_i_really's avatar
    am_i_really
    Frequent Visitor
    3 years ago

    Hi Greg_Deckler 

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

     

     

    • Greg_Deckler's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity Champion
      3 years ago

      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