Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
jibran
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
v-haibl-msft
Employee
Employee

@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
v-haibl-msft
Employee
Employee

@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

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

@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

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

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.