Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Conditional formatting help - Duplicate rows for ID

Hi All,    I was wondering if someone could help me. I am having trouble with conditional formatting in Power BI and I need some assistance. My aim is so insert another column inside of the table t...
General Comment
Need Help
  • samdthompson's avatar
    samdthompson
    4 years ago

    You need to return Time as a measure. Currently thats just the rows from a table. Youll need two measures:

     

    Hours=SUM(Table1[Time])

     

    Then the conditional measure

     

    Example=SWITCH(TRUE(),[Time]=60,1,[Time]=30,0.5,0)

     

     

samdthompson's avatar
samdthompson
Memorable Member
4 years ago

You need to return Time as a measure. Currently thats just the rows from a table. Youll need two measures:

 

Hours=SUM(Table1[Time])

 

Then the conditional measure

 

Example=SWITCH(TRUE(),[Time]=60,1,[Time]=30,0.5,0)