Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

How to write ForEach function in Power BI

Experts, please help me to write the below code in Power BI Dax.   =If(IsNull([Shiftstarttime])ForEach([Shift_End_Date]);"";FormatDate([Shiftstarttime];"h:mm a"))   Thanks, Bala
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

    Please try create a column:

    Column = 
IF(
    'Table'[Shift_End_Date] = BLANK(),
    "",
    FORMAT('Table'[Shiftstarttime],"h:mm AM/PM"
    )
)

     

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thanks Greg_Deckler, I am a begginer in DAX and not able to convert the below syntax in DAX. pls help with the DAX code.

     

    =If(IsNull([Shiftstarttime])ForEach([Shift_End_Date]);"";FormatDate([Shiftstarttime];"h:mm a"))