Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Not sure what is aspnet_membership table like. I assuming we have a table like below.
We can create a measure with following DAX formula.
Measure = CALCULATE ( DISTINCTCOUNT ( aspnet_membership[Customer Join] ), aspnet_membership[CreateDate] = TODAY () )
Best Regards,
Herbert
Not sure what is aspnet_membership table like. I assuming we have a table like below.
We can create a measure with following DAX formula.
Measure = CALCULATE ( DISTINCTCOUNT ( aspnet_membership[Customer Join] ), aspnet_membership[CreateDate] = TODAY () )
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())
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
107 | |
69 | |
68 | |
43 |
User | Count |
---|---|
148 | |
104 | |
102 | |
89 | |
66 |