Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Dear All,
In my sales report I do have 'actual sales' and 'linear sales estimates' columns. For the 'linear sale estimates' I use the basic formula:
Actual working days until prev day = Calculate(
Solved! Go to Solution.
Hi @Giorgi1989 ,
Please update the formula of measure [Actual working days until prev day] as below and check whether it can get your expected result...
Note: The part with red font is updated one.
Actual working days until prev day = CALCULATE ( COUNTROWS ( 'Dates' ), DATESBETWEEN ( Dates[Date], IF ( DAY ( TODAY () ) = 1, DATE ( YEAR ( TODAY () - 1 ), MONTH ( TODAY () - 1 ), 1 ), DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ), 1 ) ), TODAY () - 1 ), 'Dates'[IsWorkingDay] = TRUE () ) |
If the above one can't help you get the correct result, please provide some sample data with Text format and your expected result with calculation logic and special examples. Thank you.
Best Regards
Thank you for the feedback and support! Will try those out!
Hi @Giorgi1989 ,
Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem with you. Thank you.
Best Regards
Hi @Giorgi1989 ,
Please update the formula of measure [Actual working days until prev day] as below and check whether it can get your expected result...
Note: The part with red font is updated one.
Actual working days until prev day = CALCULATE ( COUNTROWS ( 'Dates' ), DATESBETWEEN ( Dates[Date], IF ( DAY ( TODAY () ) = 1, DATE ( YEAR ( TODAY () - 1 ), MONTH ( TODAY () - 1 ), 1 ), DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ), 1 ) ), TODAY () - 1 ), 'Dates'[IsWorkingDay] = TRUE () ) |
If the above one can't help you get the correct result, please provide some sample data with Text format and your expected result with calculation logic and special examples. Thank you.
Best Regards
@Giorgi1989 , Work day as measures
Work Day = COUNTROWS(FILTER(ADDCOLUMNS(CALENDAR(Min(Date[Date]),Today() -1),"WorkDay", if(WEEKDAY([Date],2) <6,1,0)),[WorkDay] =1))
a new column
Work Day = COUNTROWS(FILTER(ADDCOLUMNS(CALENDAR(Date[Date],Ttoday() -1 ),"WorkDay", if(WEEKDAY([Date],2) <6,1,0)),[WorkDay] =1))
How to calculate Business Days/ Workdays, with or without date table: https://youtu.be/Qv4wT8_P-AA
User | Count |
---|---|
42 | |
27 | |
24 | |
20 | |
16 |
User | Count |
---|---|
54 | |
35 | |
19 | |
18 | |
15 |