Saving measure value into table

[KevinOGC]

Hi everyone,

I have a table 'advertisements' which looks like below:

id	is_online
1	true
2	false
3	false
4	true
5	true
6	false

I want to count the unique id where online is true, so I made the DAX like below:

Online Ads = CALCULATE(

DISTINCTCOUNT(Advertisements[id]);

FILTER (Advertisements;Advertisements[is_online]=True))

Now the is_online status changes over time and I want to save this measure in a table on a daily basis (at a specific moment) which should look like:

date	is_online
1/1/2019	2
1/2/2019	6
1/3/2019	2
1/4/2019	4
1/5/2019	1
1/6/2019	4

How can I achieve this?

[v-chuncz-msft]

@KevinOGC 

You may refer to the following posts.

• https://community.powerbi.com/t5/Desktop/Create-date-Parameter-asat-date-to-get-active-customers/m-p...
• https://community.powerbi.com/t5/Desktop/Trend-from-History-Table/m-p/200304#M88115
• https://community.powerbi.com/t5/Desktop/Accumulate-sum-minus-abandoned/m-p/206947#M91174

[KevinOGC]

@v-chuncz-msft  thanks a lot for your answer!

There is no colum/table with the is_online date, so I need to count the is_online daily and save it to somewhere. All the given examples using an available date.

Are there options without a date is_online relation?