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

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