Forum Discussion
Switch True
hi Anonymous
This a "start date and end date" problem, very common, you could refer to this similar post:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365
If you still have problem, please share some simple sample data and what your expected output like.
Regards,
Lin
I think im al most there, how do you create a measure that turn a True column into ones and zeros
hi Anonymous
Share some simple sample data and your expected output, that will be a great help.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Regards,
Lin
Hi
Sorry for the delay, here basically what I wanted, I have a column that has "Acttive" or "Inactive". I worte an if statement that add a new column with 1's and 0's (what you see in the picture). If that value is 1 then the color with be Green to let me know that machine is active. I wanted the DeviceName to change colors if the device was active or not. But this is the best solution I could come up with .