cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Super User III
Super User III

Re: Remove cumulative total

Hi @JurriaanQEL

 

In the file you sent, there is no relationship between the dim_date and v_f_Bordereau tables.

 

When I create a relationship,the left table shows both Cumulative and Monthly Figures.

 

Right table has missing fields (probably because you deleted some data). So it is not showing up in the File You sent

Regards,
Zubair


Highlighted
Regular Visitor

Re: Remove cumulative total

Hi @Zubair_Muhammad

 

Ok, so I am close... 

May I ask you to share the file where you managed it with the relationships? Because even with that I am struggling (can't autodetect, or can't create relationship because one of the columns must have unique values)... I think I need to do a course in Power BI...

It's correct that the right table isn't working, I removed one field too many, but since that one was just to show you what numbers there are it wasn't very relevant anyway (and it was showing in the picture).

 

Thanks as always, very much appreciated.

 

Kind regards,

Jurriaan

Highlighted
Super User III
Super User III

Re: Remove cumulative total

Hi @JurriaanQEL

 

Here it goes

 

https://1drv.ms/u/s!AhiuKaBxxAufjlj_7cIa7Xllk9u4

 

See the First item with No Month YEAR but a figure for CA Indemnity Paid.

I believe it means your Dim_Date doesot contain all the necessary dates.

 

These books are precious for learning DAX

 

Learn to Write DAX: A practical guide to learning Power Pivot for Excel and Power BI

Definitive Guide To DAX

Regards,
Zubair


Highlighted
Regular Visitor

Re: Remove cumulative total

Hi again @Zubair_Muhammad,

 

I thinky you might be on to something.

There is indeed another column that has a date field. 

I've uploaded the less-stripped version:

https://1drv.ms/u/s!AiecK9GUkh9Aqy7ukkq6ENOQ288c

The date field consists of year,quarter,month and day. How would that hold up in the DAX?

 

Cheers

Highlighted
Anonymous
Not applicable

Re: Remove cumulative total

Hi @Zubair_Muhammad,

Its works for me when there is only date in the table, but the moment I add third column, it gives me the wrong result.
For instance, I have date, country and CumulativeSales and I need daily sales. 


Please can you assist on this one as well.

 

I have modified the data in your pbix file itself. Please check this here. 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

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!.

Top Solution Authors
Top Kudoed Authors
Users online (848)