hello
monday logins = CALCULATE( sum( ‘tableName’[logins] ), “Date = ‘2023-05-29’” )
do you know how I can adjust this measure so that I get a measure to show logins on mondays?
thank you
hello
monday logins = CALCULATE( sum( ‘tableName’[logins] ), “Date = ‘2023-05-29’” )
do you know how I can adjust this measure so that I get a measure to show logins on mondays?
thank you
Do you have a date table in your model?
If yes, if you don’t already have one, add a day of the week column in the date table. My date table has Sunday as day 1.
CALCULATE( sum( ‘tableName’[logins] ),
'Date'[Weekday No] = 2)
Hello @arkiboys
Did the responses above help solve your query?
If not, can you let us know where you’re stuck and what additional assistance you need?
If it did, please mark the answer as the SOLUTION by clicking the three dots beside Reply and then tick the check box beside SOLUTION
Thank you