Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
hello guys i want a measure to calculate my net profit from my selected date on slicer to the initial date:
example my datetable starts on august 1st, if i select october, i want the measure to calculate net profit from august to october, if i select november, i want it to calculate from august to november...
my date slicer is like this so if i choose october i want the calculation to include august to october. i know i can select it aall but im tryin to create another calculation that requires me to create this measure
Solved! Go to Solution.
i found a solution wit the emasure below :
before = VAR seldate = MAX(DateTable[Date]) RETURN CALCULATE([Net Profit],DATESBETWEEN(DateTable[Date],"8/1/2022",seldate))
i found a solution wit the emasure below :
before = VAR seldate = MAX(DateTable[Date]) RETURN CALCULATE([Net Profit],DATESBETWEEN(DateTable[Date],"8/1/2022",seldate))
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
11 | |
9 | |
8 | |
8 | |
7 |
User | Count |
---|---|
14 | |
12 | |
11 | |
10 | |
9 |