cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

previous month and date table relation

hi

i am having trouble geting correct data using both previous month formulas 

i did as instructed, created a date table, then i linked the date coulumn of it with a date coulumn in another table

i faced several problems: 

1- tried to create a calnder coulumn in my Account card table. it didnt work, then i linked the date table with one of the coulmns that are a date format. 

2- when performing the previous month function, it gives me the correct answer of every current month! not the previous month 

 

i used these: 

Previous_Month_current_balance = CALCULATE(SUM('EVS Account'[Current_Balance]),PREVIOUSMONTH('DimDate'[Date]))

and :

Previous_Month_current_balance = CALCULATE(SUM('EVS Account'[Current_Balance]),DATEADD(DimDate[Date],-1,MONTH))

 

i think my problem is with the relationship, what kind of date colomn should i link the date to?

 

please help. so frustrated

thanks

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: previous month and date table relation

Hi Ranahazim,

 

What's relationship between 'DimDate' and 'EVS Account', many-to-one or one-to-many? In addtion, if possible, you can merge the tables and check if your measure can work.

 

Regards,

Jimmy Tao

View solution in original post

3 REPLIES 3
Highlighted
Community Support
Community Support

Re: previous month and date table relation

Hi Ranahazim,

 

What's relationship between 'DimDate' and 'EVS Account', many-to-one or one-to-many? In addtion, if possible, you can merge the tables and check if your measure can work.

 

Regards,

Jimmy Tao

View solution in original post

Highlighted
Frequent Visitor

Re: previous month and date table relation

hi, 

the relationship is many to one 

I tried merging tables but after edit queries, the Dimdate table which i added wasnt visible to be merged. i added the dimdate table but not using sql query.

 

 

Highlighted
Frequent Visitor

Re: previous month and date table relation

am trying many things with no results yet 

Helpful resources

Announcements
Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors