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.
On a Power BI dashboard, I dont have any date slicer selected at any level(visual, page level, report level).
I have a date table.
I have a YTD measure using TOTALYTD(sum(Sales[Revenue ]),'DateTable'[Date]) for a list of targeted accounts. and it seems to give me a reasonable value. I am just curious if power BI defaults today as the date to go into " 'DateTable'[Date]" , if no date is selected or filtered anywhere.
Thanks!
NM
Solved! Go to Solution.
Hello,
TOTALYTD cumulates Revenues till the last day selected. If no date is filtered sliced or anything it cumulates till the last date of date table.
Best regards.
Hello,
TOTALYTD cumulates Revenues till the last day selected. If no date is filtered sliced or anything it cumulates till the last date of date table.
Best regards.
it makes sense. Thank you for your reply!
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 |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |