Forum Discussion
How do I get the current date from totalling
hi,
I have a measure called "Current Date", which is todays date.
When I put in in a table with records from another table, it give me a total line under the Current Date:
Hi EaglesTony ,
Thank you for engaging with the Microsoft Fabric Community. The reason you're seeing a total line under the Current Date column is because it's a measure that returns the same value ( Today() or NOW()), and Power BI automatically includes this in the total row of the visual. Since it's not an aggregated value (like SUM or AVERAGE),
Go to the Format pane → Totals → Disable Totals for Current Date to prevent any unwanted aggregations.FYI:
When Total-Values is OFF
FYI:
When Total-Values is ON
For more details, please review the attached PBIX file.
If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
2 Replies
What are you expecting to see? What's the problem you're trying to solve?
Hi EaglesTony ,
Thank you for engaging with the Microsoft Fabric Community. The reason you're seeing a total line under the Current Date column is because it's a measure that returns the same value ( Today() or NOW()), and Power BI automatically includes this in the total row of the visual. Since it's not an aggregated value (like SUM or AVERAGE),
Go to the Format pane → Totals → Disable Totals for Current Date to prevent any unwanted aggregations.FYI:
When Total-Values is OFF
FYI:
When Total-Values is ON
For more details, please review the attached PBIX file.
If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
