Forum Discussion
Measure Dax Help
hi Anonymous
WEEKDAY(<date>, <return_type>)
add a parameter in the formula
return_type A number that determines the Return value:
Return type: 1, week begins on Sunday (1) and ends on Saturday (7). numbered 1 through 7.
Return type: 2, week begins on Monday (1) and ends on Sunday (7).
Return type: 3, week begins on Monday (0) and ends on Sunday (6).numbered 1 through 7.https://docs.microsoft.com/en-us/dax/weekday-function-dax
Then adjust the formula as below:
CALCULATE(COUNTROWS(FILTER(ALLSELECTED(PBI),[WEEKDAY]<6)))If you still have the problem, please share a simple sample pbix file, and your expected output.
Regards,
Lin
hi Anonymous
WEEKDAY(<date>, <return_type>)
add a parameter in the formula
| return_type | A number that determines the Return value: Return type: 1, week begins on Sunday (1) and ends on Saturday (7). numbered 1 through 7. Return type: 2, week begins on Monday (1) and ends on Sunday (7). Return type: 3, week begins on Monday (0) and ends on Sunday (6).numbered 1 through 7. |
https://docs.microsoft.com/en-us/dax/weekday-function-dax
Then adjust the formula as below:
CALCULATE(COUNTROWS(FILTER(ALLSELECTED(PBI),[WEEKDAY]<6)))
If you still have the problem, please share a simple sample pbix file, and your expected output.
Regards,
Lin
Hi v-lili6-msft
I still cant do it... maybe the model doesnt allow it.
If you can take a look at my sample data would be so nice:
PBIX:
https://www.dropbox.com/s/7jtgn0e65ongubv/BI%20VISITAS%20DEMO%20forum.pbix?dl=0
Desire output in excel:
https://www.dropbox.com/s/r7eih1bzsw76edo/DISIRED%20OUTPUT.xlsx?dl=0