Forum Discussion

Budfudder's avatar
Budfudder
Helper IV
9 years ago

Using Dates on X-Axis

I have a very simple table - a number of date/times from 2012 to the present, with, for each date/time, the details of a particular item created that is relevant to our business. I want to turn that ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Budfudder,

In your scenario, you can firstly create a date table using the following formula, then create relationship between date table and your original table using date fields.

Table = CALENDAR(DATE(2012,1,1),DATE(2016,12,31))

Secondly, create a measure in your original table using the formula below.

Measure = COUNTA(Table1[item])+0

Thirdly, create visuals using date field from date table and the measure in your original table. For more details, please review the attached PBIX file.

 

Thanks,
Lydia Zhang