Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Folks,
I am working on creating a conditional column like the below:
Condition | Values in new column |
contract to expire in 15 days from the current date | - 15 days |
contract to expire in 30 days from the current date | - 30 days |
contract to expire in 60 days from the current date | - 60 days |
contract to expire in 90 days from the current date | - 90 days |
I want the new column to be used as a filter/slicer in my report. My desired slicer outcome is
But what I get is:
Can anyone please help me here?
The logic used by me- if [expiry days]>0 and [expiry days]<60 then 60 days
if [expiry days]>0 and [expiry days]<90 then 90 days
Solved! Go to Solution.
Hello @Anonymous ,
You can achieve the desired result by separately creating column with each of this condition.
Please find my attached pbix file here pbix file
Hello @Anonymous ,
try using with: if [expiry days]>0 and [expiry days]<90 then 90 days
if [expiry days]>0 and [expiry days]<60 then 60 days
Thanks but this does not help
Hello @Anonymous ,
You can achieve the desired result by separately creating column with each of this condition.
Please find my attached pbix file here pbix file
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |