Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
SumeetBankar
Regular Visitor

I have 3 columns period ,invoice due date & amount in a single table.

I have 3 columns period,invoice due date & amount in a single table.

 

Now what i want is if period is last month 31-03-2022 and amount is 100,then i will check invoice due date of april and amount would be 30. So I want to show that 30 amount in my kpi.

 

2 REPLIES 2
ribisht17
Super User
Super User

This is not clear to me  and kindly post some data

 

Regards.

Ritesh

You can see in below image for the period of 31-12-2021, i'm getting invoice due date & amt 

But what I want to show as a Target in dashboard is the amt i'm getting in jan 2022 - 2334107463.

This amt i want to show as target in my dashboard

SumeetBankar_0-1650644872130.png

 

 

This is my base data

 

SumeetBankar_1-1650645017337.png

 

so I have invoice due date of every month but I want to show invoice due of next month so

if period is 31-12-2021 then due amt of jan 2022 , 

if period is 31-01-2022 then due amt of feb 2022 etc

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors