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.
I have made the new column called BDFT which is great! However it calculates everything all the days and times. I want to make two columns of BDFT..using the formula BDFT = Qty * Volume, I want one that calculates Qty * Volume between 4:00 AM and 1:59 PM and the other one at evening which is between 2:00 PM and 2:00 AM. How do I go about doing it?
This way I will have two custom columns one called Day BDFT and the other one is Night BDFT.
Solved! Go to Solution.
Hi @Anonymous ,
I create two columns so that it might be easier to see. HOUR() returns 1-24, so notice that there is an OR which is || .
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Day = If(Hour('Table (3)'[Column1])>4 && Hour('Table (3)'[Column1])<14,"Day") Night = if(HOUR('Table (3)'[Column1]) >= 14 && HOUR('Table (3)'[Column1]) <24 || HOUR('Table (3)'[Column1]) <2 ,"Night")
Proud to be a Super User!
Hi @Anonymous ,
I create two columns so that it might be easier to see. HOUR() returns 1-24, so notice that there is an OR which is || .
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Day = If(Hour('Table (3)'[Column1])>4 && Hour('Table (3)'[Column1])<14,"Day") Night = if(HOUR('Table (3)'[Column1]) >= 14 && HOUR('Table (3)'[Column1]) <24 || HOUR('Table (3)'[Column1]) <2 ,"Night")
Proud to be a Super User!
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.