Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have this data where I need to calculate 2 calculations for previous, current and next month. Basically to track which payemnt are guaranted in current month, how much much will be guranted next month. Not sure why chart is showing equal bars
Hi @annam
Are you usinga Date Table in your Data Model? If yes, please tyr this.
Invoiced =
SUM(Table[Total Amount])
Est. invoice =
CALCULATE([Invoiced], USERELATIONSHIP(Date[Date], Table[Est. Invoice Date]))
Invoice Accepted =
CALCULATE([Invoiced], USERELATIONSHIP(Date[Date], Table[Invoiced Accepted Date])
Add the date from the date table to a visual then the measures
Hope this helps
Joe
Proud to be a Super User! | |
Date tables help! Learn more
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
22 | |
7 | |
6 | |
6 | |
6 |
User | Count |
---|---|
27 | |
12 | |
10 | |
9 | |
6 |