Forum Discussion
Switch True
Anonymous not fully clear what you are trying to achieve, paste some sample data, and expected output. Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
In the picture below are the start and end time for different devices. I want to know is it possible to create a visual using the SwitchTrue() function, that will change colors if someone has scanned in or out of that device
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
