Forum Discussion

Benjamin4312's avatar
Benjamin4312
Frequent Visitor
2 years ago
Solved

How to differentiate between target and actual per month using only one dataset

Hello guys   We want to track project savings with Microsoft Lists in Sharepoint Online. I created the lists as follows: One Line of data for planned and actual and the savings are distributed over...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Benjamin4312 

     

    I can give you some further suggestions for your idea.Once your data is in Power BI, you can create calculated columns or measures to differentiate between planned and actual values and perform your YTD calculations or any other analysis. 

    For example ”3/17/2024 - 5/17/2024“.You can use the following DAX to break them apart:

     

    actual = LEFT('Table'[Column1],10)
    planned = RIGHT('Table'[Column1],10)

     

     This is the result:

     

    Then you just need to change the format of the new column to date format.

     

     

     

     

    Best Regards,

    Jayleny

     

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Benjamin4312 

 

I can give you some further suggestions for your idea.Once your data is in Power BI, you can create calculated columns or measures to differentiate between planned and actual values and perform your YTD calculations or any other analysis. 

For example ”3/17/2024 - 5/17/2024“.You can use the following DAX to break them apart:

 

actual = LEFT('Table'[Column1],10)
planned = RIGHT('Table'[Column1],10)

 

 This is the result:

 

Then you just need to change the format of the new column to date format.

 

 

 

 

Best Regards,

Jayleny

 

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