I have a simple table that shows me in column [Date] the date for order creation.
Now I would like to add a calculated column that shows me the following information.
If [Date] - TODAY()
How would you do that? Using a SWITCH or IF?
Go to Solution.
SWITCH ( TRUE(), ... ) should do the trick nicely:
Example from the article:
SWITCH( TRUE(), [Overall Store Rank]<10,”Under 10″, [Overall Store Rank]<20,”Under 20″, [Overall Store Rank]<30,”Under 30″, “Over 30” )
View solution in original post
Click here to read more about the December 2021 Updates!
Mark your calendars and join us for our next Power BI Dev Camp!
Learn how to create your own user groups today!