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 All,
Hope everyone is doing great.
I have an issue while creating a new column in power bi desktop. i have ageing information and i need to create a ageing bucket column based on the ageing data.
Here while creating the new column, there is a condition like if (ageing<(Today()-MonthEnd(Today)),"Category1",Category2"). As i am new to powerBI i am not able to solve this. Can someone please help.
Br,
Ravi
Solved! Go to Solution.
Hi Ravi,
Try the below Calculated Measure.
if( Ageing < (Format(Now(),"DD/MM/YYYY") -
Hi Ravi,
Try the below Calculated Measure.
if( Ageing < (Format(Now(),"DD/MM/YYYY") -
Thanks for the quick response Pavan. I have used the logic given by you in the expression and i got the desired result.
Br,
Ravi
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |