Forum Discussion

PaulCr125's avatar
PaulCr125
Frequent Visitor
7 years ago
Solved

DAX Measure ?

Below is my example... In Excel it's easy. In Power BI... I'm struggling... User selects a begin date and end date. In the selection there is 22 work days between begin Date and end date. (Date calc...
Need Help
  • Ronald123's avatar
    Ronald123
    7 years ago

    Hello PaulCr125,

     

    Try this measure. 

     

     




     

     

     

     

     

     

    Greets,

     

    Ronald

     

Ronald123's avatar
Ronald123
Resolver III
7 years ago

Hi PaulCr125,

 

The problem must be you measure [Daysinperiod].

Put the measure in the matrix and check the value of every row.

 

If that isn't problem, please upload a sample of your data.

 

Greets,

 

Ronald

PaulCr125's avatar
PaulCr125
Frequent Visitor
7 years ago

That's the problem.... the days in period needs to say constant...

If I hard code the 10 into the Calc_Col_II = FORMAT(DIVIDE([DAX_Hours],10*7,2),"0.00%") , it works fine.

 

I need the DaysInPeriod Measure to equal the the date difference in the slider begin date and end date and stays constant. 

 

 

  • Ronald123's avatar
    Ronald123
    Resolver III
    7 years ago

    Hello PaulCr125,

     

    Create a date table;

     

    DateTable=CALENDAR (MINX (Date, [TicketDate]), MAXX (Date, [TicketDate]))

    Make a connection between Date[TicketDate] >DateTable[Date]

     

    Then drag the date colum from the date table in the slicer.

     

    At last, make you're [DaysInPeriod] measure with the dates from the DateTable.

     

    Greets,

     

    Ronald

  • PaulCr125's avatar
    PaulCr125
    Frequent Visitor
    7 years ago

    Ronald123,

        That did it... I also understand the theory, and was not aware of the usage of MAXX. I appreciate your patience to bring me through the interative steps to actully understand my solution. Many questioners want it done for them... that returns nothing in knowledge. I will take the knowledge forward, thanks again for your help.

    Paul