This content has been marked as final. Show 7 replies
I can't get set expressions working with dates. e.g. Show me only row counts for first day of last month.
The column is calculated as:
I would expect to see values in the 2nd and 4th row, but instead I see 0 for every row. The date format seems to match (as you can see in KPI indicator). The data model is super simple:
date(date#(date, 'YYYY-MM-DD'), 'DD/MM/YYYY') as [Date],
date(date#(activation_date, 'YYYY-MM-DD'), 'DD/MM/YYYY') as [Activation Date];
cast(created as date) as date,
cast(activation_date as date) as activation_date
What am I doing wrong?