Forum Discussion

EduardoOrtega's avatar
EduardoOrtega
Regular Visitor
3 years ago

Help with conditional formulas.

Good day, I am new to using Power BI and I request your valuable help. I have the following set of data coming from a folder with very heavy Excel files:   What I need is a formula or so...
Need Help
EduardoOrtega's avatar
EduardoOrtega
Regular Visitor
3 years ago

First of all, thank you very much for your support, but I don't know how to use what you replied with my data or how to get the result. What you provided is very helpful, it's exactly what I want, I just don't know how to add it to my data. Beacuse i do not have those two tables min & max.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi EduardoOrtega ,

You can create 2 columns.I used these two columns to fix the time.

Then change the result column.

Column = IF (
     ( 'Table'[datetime] ) >=  ( 'Table'[min_time] )
        &&  ( 'Table'[datetime] ) <=  ( 'Table'[max_time] ),
    "Same period",
    "Other period"
)

How to Get Your Question Answered Quickly 

 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

 

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.