It might seem strange but I have a requirement to show one value for all days of a month.
In database, there are records only for the first day of months. When I create analysis in BI with day prompt, obviously I get null values for every day except the first day of a month. How can I fix this measere(value in 01.01.2018, 01.02.2018 etc.) for all days? Of course when months changes column should present the value of first day of the next month. Is there a way to do this?
Set the aggregation rule to FIRST for the meaasure on the Time dimension, level Month, and to SUM for all others.