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.
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.
Slicers dont work as its not relational.
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:] ) )
)
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 |
---|---|
106 | |
105 | |
79 | |
69 | |
61 |
User | Count |
---|---|
143 | |
104 | |
103 | |
82 | |
70 |