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 |
---|---|
114 | |
101 | |
78 | |
75 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |