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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors