Forum Discussion

dorsey's avatar
dorsey
Regular Visitor
5 years ago
Solved

trouble with calculated column

Hello,   First sorry for my english. I'm a very newby on powerBI but everything becom with a start no ? I've a table with some column : - [first] date for when the holiday start , - [second] da...
Need Help
  • selimovd's avatar
    selimovd
    5 years ago

    Hey dorsey ,

     

    that usually happens when you mix data types.

    I guess [third] is number, no? Then try it like this:

    Colonne = IF( [forth]="day", [third], 0.5)

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     
dorsey's avatar
dorsey
Regular Visitor
5 years ago

Hello,

 

 and thank you for your two help. It's working and it's awsome !!

 

Nothing for you maybe but for me it's a big start !

 

regards

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    5 years ago

    Hey dorsey ,

     

    I'm happy it works now 😊

    The beginning is always the hardest. Keep going and things will become more and more easy. And we can always help you here in the community.

     

    Best regards

    Denis