General help/advance.

[drwinny]

Hi All,

I am uisng power BI service and want to display my data in a certain way but I have no idea how to do it.

I want to use sales data to calculate failure rate but I am not interested in the date I just need to show it as first month after launch. 

Like the examples below:

Would anyone be kind enough to help me understand how I would try and do this in power BI service.

Thank you.

Sean.

[Anonymous]

@drwinny 

You have to post the raw data somehow. It can be a link to a file on a shared drive. Google or OneDrive or a file-sharing service...

[drwinny]

let me see what I can do about sample data, I think what I need to do is called resetting the row or row over partition in SQL maybe grouping in Power BI