Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi
I have a newbie question about using VAR and Switch. I am trying to create a RAG report based on the last update age bracket to records in a data table.
I have created a custom column in query editor as = Table.AddColumn(#"Added Custom2", "UpdateAgeBracket", each if [Daysfromupdate] <30 then "<30 Days" else
if [Daysfromcreated]>=30 and [Daysfromupdate] <90 then "30 to 90 Days" else ">90 Days")
I then created 2 DAX measures in PowerBI desktop
Hi @triciablakeyequ ,
Would u please mind sharing the sample data. I did not really follow the question based on the information provided.
Hi @Anonymous ,
I don't quite understand what you mean, like:
VAR Green = 0.29
VAR Amber = 0.30
VAR Red = 0.90
Do you mind providing some sample data that does not contain sensitive information?
Hope it helps,
Community Support Team _ Caitlyn Yan
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
It looks like you are comparing row counts with decimal values less than 1. That doesn't make much sense to me.
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |