The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I have this command:
Solved! Go to Solution.
Please try
Measure1 =
CALCULATE (
COUNT ( 'AMS Flights Data'[Arr/ Dep] ),
DATEADD ( 'Date'[Date], -7, DAY )
)
I tried Allselected but no data is showing in my chart:
I have a date table though the formula works fine with out filtering it shows the last 7 days according to the date I use, but when I apply a filter on the chart itself it does not change.
Please try
Measure1 =
CALCULATE (
COUNT ( 'AMS Flights Data'[Arr/ Dep] ),
DATEADD ( 'Date'[Date], -7, DAY )
)
I tried but it shows no value and its weird, even without filter this formula shows Blank.
Please make sure you're using only the date column from the date table in your visual and slicers.
Thanks it worked when I used callendar date
I tried but it shows no value and its weird, even without filter this formula shows Blank.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
63 | |
32 | |
21 | |
16 | |
15 |
User | Count |
---|---|
94 | |
33 | |
30 | |
24 | |
21 |