Forum Discussion

ravindrapbi's avatar
ravindrapbi
New Member
7 years ago
Solved

passing dynamic values in If condition while creating a new column

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 agein...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Ravi,

     

    Try the below Calculated Measure.

     

    if( Ageing < (Format(Now(),"DD/MM/YYYY") - 

    FORMAT(EOMONTH(NOW(),0),"DD/MM/YYYY")),"C1","C2").
     
    Let me know if you need any help.
     
    Regards,
    Pavan Vanguri.
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Ravi,

 

Try the below Calculated Measure.

 

if( Ageing < (Format(Now(),"DD/MM/YYYY") - 

FORMAT(EOMONTH(NOW(),0),"DD/MM/YYYY")),"C1","C2").
 
Let me know if you need any help.
 
Regards,
Pavan Vanguri.
ravindrapbi's avatar
ravindrapbi
New Member
7 years ago

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