cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

Dax measure to show count of today's date data

Hi,

I am working on to create a sales dashboard for our team and stuck on one of the formula in which I want to show total amount of customers join us on today's date. When customer join our portal we store the date as of Create date on our database. I tried this formula 

TodayDate = FILTER(aspnet_membership,aspnet_membership[CreateDate] = TODAY())

 But it cameup with an error that Multiple columns cannot be converted to a scalar value.

Can you please assist me on this?

 

I can provide more information with screen shot if needed.

 

Many Thanks

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

@jibran

 

Not sure what is aspnet_membership table like. I assuming we have a table like below.

Dax measure to show count of today's date data_1.jpg

 

We can create a measure with following DAX formula.

Measure = 
CALCULATE (
    DISTINCTCOUNT ( aspnet_membership[Customer Join] ),
    aspnet_membership[CreateDate] = TODAY ()
)

Dax measure to show count of today's date data_2.jpg

 

Best Regards,

Herbert

View solution in original post

5 REPLIES 5
Highlighted
Microsoft
Microsoft

@jibran

 

Not sure what is aspnet_membership table like. I assuming we have a table like below.

Dax measure to show count of today's date data_1.jpg

 

We can create a measure with following DAX formula.

Measure = 
CALCULATE (
    DISTINCTCOUNT ( aspnet_membership[Customer Join] ),
    aspnet_membership[CreateDate] = TODAY ()
)

Dax measure to show count of today's date data_2.jpg

 

Best Regards,

Herbert

View solution in original post

Highlighted

Hi,

I tried to add below formula but still is not displaying today's date data.

Formula that I use is 

Vehicle Addition Counter1 = CALCULATE ( DISTINCTCOUNT( vehicles[ID] ), Vehicles[DateAdded] = TODAY())

 date added.JPG

Highlighted

@jibran

 

Which visual did you use for this measure “Vehicle Addition Counter1”?

If possible, could you please provide your PBIX file to me?

 

Best Regards,

Herbert

Highlighted

Hi Herbert,

Thanks for your help actually your formula was right I just had to change the date transformation to make it worked

Thanka a lot for your help

Many Thanks

 

Jibran Ishtiaq

Highlighted

Hi @jibran,

 

I'm not getting anything using this formula. Could you please explain how you transformed the date.

 

Thank you

Regards

Sunil

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors