Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
Hello,
I currently use
So I have a Table that look like this
date | average |
2023-03-01 | 4 |
2023-03-02 | 5 |
2023-03-03 | 8 |
2023-03-04 | 4 |
2023-03-05 | 6 |
2023-03-06 | 9 |
2023-03-07 | 3 |
2023-03-08 | 1 |
2023-03-09 | 12 |
2023-03-10 | 6 |
I absolutly need the whole table but if I want to calculate only for dates 2023-03-01 to 2023-03-06, how would I do that?
Thank you
Solved! Go to Solution.
Hi @JeremieA
You can slice your measure in several ways.
For example :
You can create a calendar table
Create a relationship with your data table:
And put the date from the calendar on your slicer
From this moment your measure is dynamic
You can download sa,ple file from here:Link
More information about calendar tables is here:
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
I found a way
Thank you for the response, but I have to make this measure in around 50 differents, non related table in my dashboard, using a slicer would be less than optimal
Hi @JeremieA
To be able to help, I recommend fully and clearly describing what is required and what the desired result is.
I found a way
Hi @JeremieA
You can slice your measure in several ways.
For example :
You can create a calendar table
Create a relationship with your data table:
And put the date from the calendar on your slicer
From this moment your measure is dynamic
You can download sa,ple file from here:Link
More information about calendar tables is here:
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
User | Count |
---|---|
86 | |
82 | |
42 | |
40 | |
35 |