Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.
I have two tables, one with sales data by day, with a running total.
At the moment I get excel file that has sales information in, I get another request from another source but its a single date, it is NOT and CANNOT be relational to the sales data.
Two tables
Slicers dont work as its not relational.
Result
I wnat the users date to populate two CARDS with the two figures, Sales and total sales
Solved! Go to Solution.
You could add a calculated column to your sales day by day table, like
SlicerCol =
IF( Sales[Data Date:] = MIN( SingleDate[DataDate] ), "The Date", "Not The Date" )
Or you can add a filter to applicable measures, like
Sales_TheDate =
CALCULATE(
SUM( Sales[Sales] ),
KEEPFILTERS( TREATAS( VALUES( SingleDate[DataDate] ), Sales[Data Date:] ) )
)
Thank you, I am very new at this - I was googling for weeks on how to select like in SQL and just dispaly the numbers (select sales from sales where date = 3 june 23) type uery but this is great, I never ask but this was frustrating. Will do a cource soon on Power BI and the new MS Fabric.
You could add a calculated column to your sales day by day table, like
SlicerCol =
IF( Sales[Data Date:] = MIN( SingleDate[DataDate] ), "The Date", "Not The Date" )
Or you can add a filter to applicable measures, like
Sales_TheDate =
CALCULATE(
SUM( Sales[Sales] ),
KEEPFILTERS( TREATAS( VALUES( SingleDate[DataDate] ), Sales[Data Date:] ) )
)
Check out the May 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
72 | |
67 | |
67 | |
44 | |
42 |
User | Count |
---|---|
47 | |
38 | |
28 | |
28 | |
27 |