Forum Discussion

codingenthu's avatar
codingenthu
Frequent Visitor
2 years ago

Creating a common YearMonth column in Power BI

Hi, In Power BI, I'm working with a WorkStationAudit Table containing columns such as StartDate, EndDate, CreatedDate, ResolutionDate, and Issuekey. My aim is to generate a Line and Clustered Colu...
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi, codingenthu 

Based on your information, I create a sample data table:

 

Create a calculated column :

YearMonth = FORMAT('Table'[StartDate], "YYYY-MM")

 

Then create two measures :

Actual Count = CALCULATE(SUM('Table'[Issuekey]), FILTER(ALL('Table'), 'Table'[ResolutionDate] <= MAX('Table'[ResolutionDate])))

Planned Count = CALCULATE(SUM('Table'[Issuekey]), FILTER(ALL('Table'), 'Table'[StartDate] <= MAX('Table'[StartDate])))

 

Here is my preview:

 

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

codingenthu's avatar
codingenthu
Frequent Visitor
2 years ago

Anonymous Thank you for the reply!!

Actually in the visual i want to see both Actual and Planned Lines. So what i was trying to say is If i create YearMonth column based on StartDate then only Planned Line seems working as we have used StartDate in the Planned Line and Actual Line seems doesn't working.