Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I have been trying build a measure with workdays and festive days.
I have discounted sunday in my variable but when I trie to discount another holiday it continues returning 1 in this case
Laboral Day =
VAR EsFinDeSemana = Dates[Number Day] IN {7}
VAR EsFestivo =
NOT ISBLANK(RELATED(TablaFestivos[Descripcion]))
VAR DiaLaboral =
IF(NOT(EsFestivo || EsFinDeSemana),1,0)
RETURN
DiaLaboral
For example:
January 6 is holiday but it counts as 1....
My table is related with a table that contains holidays
Can somebody help me please?
Thanks in advance.
Solved! Go to Solution.
Hi , @Lburgos
Here are the steps you can refer to :
(1)Here are my test data :
(2)We can create a calculated column with this dax:
Column = var _isweekend = 'Date'[Number Day] in {7}
var _fest = RELATED('TablaFestivos'[Descripcion])
return
IF( _isweekend || _fest,0,1)
(3)Then we can meet your need , the result is as follows:
If this method does not meet your needs, you can provide us with your special sample data and the desired output sample data in the form of tables, so that we can better help you solve the problem.
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi , @Lburgos
Here are the steps you can refer to :
(1)Here are my test data :
(2)We can create a calculated column with this dax:
Column = var _isweekend = 'Date'[Number Day] in {7}
var _fest = RELATED('TablaFestivos'[Descripcion])
return
IF( _isweekend || _fest,0,1)
(3)Then we can meet your need , the result is as follows:
If this method does not meet your needs, you can provide us with your special sample data and the desired output sample data in the form of tables, so that we can better help you solve the problem.
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
User | Count |
---|---|
94 | |
79 | |
74 | |
63 | |
60 |
User | Count |
---|---|
108 | |
100 | |
77 | |
63 | |
61 |