Forum Discussion

PowerBINewbie_1's avatar
PowerBINewbie_1
Helper I
8 years ago

Nested DAX

Hi,   I'm new to the DAX community and I'm completely perplexed about how to convert my excel formulas into a DAX function that works. I have about 30 columns in my worksheet that deal with dates. ...
PowerBINewbie_1's avatar
PowerBINewbie_1
Helper I
8 years ago

Hello Greg,

 

Thank you. You're in the ballpark with this solution. However, I'm looking to capture the 0's and to use the current date when a date is not provided. How would you modify your solution to do that?

 

Thanks!

PBN

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

Not sure what you mean by capture the zeros, but for the second one you can just use an VAR that has an IF statement with an ISBLANK to check if there is no date value provided and in that case set the variable equal to TODAY().

  • PowerBINewbie_1's avatar
    PowerBINewbie_1
    Helper I
    8 years ago

    Hi,

     

    In my formulas above. I'm saying, if a certain column is blank then output a "0". Otherwise, perform calculations that will give me a total of the business days between two dates. Your solution provides a way to only total the business days between dates. However, there are multiple factors that I am trying to address here. 

     

    1. If the beginning date is empty. Output a "0".

    2. If the ending date is empty use TODAY() date. To calcualte total business days

     

    3. Then ultimately sum the total business days between two dates if two dates are provided.

    4. Understand the proper way to nest IF statements that have more than 3 conditions.

     

    In my examples above, I have nested if statments that are complicated because I have to nest them properly to perform the calculations at hand. Then use the CALCULATE SUM to replace the network days excel function. Thus it gets tricky. As a newbie, examples would work best.

     

    Thanks for your input though.

     

    Regards,

    PBN