cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
yuvarajg Member
Member

Want datatype as text for date column

Hi,

 

i have the following table.

 

Date                   Count

31Jan2019           2

01Jan2019           1

22Jan2019           5

 

 

 

want to create following widget. how can i acheive.

 

 

 

Screenshot_4.png

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Want datatype as text for date column

@yuvarajg  Hope I've understood your requirement corrrectly...

 

Please create a new table as below - which will generate a calendar table with date field single column with min and max dates as boundaries from your source table. (In this example, it will be 01stJan2019 till 31stJan2019)

 

Test217DateGen = CALENDAR(MIN(Test217DateConv[Date]),MAX(Test217DateConv[Date]))

Then create a relationship between this Date table and your source table using "Date" field.

 

Create a New Measure as below

 

Test217Count = CALCULATE(SUM(Test217DateConv[Count]))+0

Then create your graph, using Date field from newly generated date table and count from source table. Also, change the "Type" of your x-axis to "Categorical"

 

image.png

 

 



Did I answer your question? Mark my post as a solution !

Proud to be a Datanaut !





1 REPLY 1
Super User
Super User

Re: Want datatype as text for date column

@yuvarajg  Hope I've understood your requirement corrrectly...

 

Please create a new table as below - which will generate a calendar table with date field single column with min and max dates as boundaries from your source table. (In this example, it will be 01stJan2019 till 31stJan2019)

 

Test217DateGen = CALENDAR(MIN(Test217DateConv[Date]),MAX(Test217DateConv[Date]))

Then create a relationship between this Date table and your source table using "Date" field.

 

Create a New Measure as below

 

Test217Count = CALCULATE(SUM(Test217DateConv[Count]))+0

Then create your graph, using Date field from newly generated date table and count from source table. Also, change the "Type" of your x-axis to "Categorical"

 

image.png

 

 



Did I answer your question? Mark my post as a solution !

Proud to be a Datanaut !