Measure displaying based on table colum (current, prior month, prior year)

[Anonymous]

Hi there, hope someone has an easy fix for a Power BI novice. 

I've got a table that is structured like this:

ID (License)	Start date	End date	Amount	Customer	Status

I manged to create measures to show e.g. the sum of amounts of all items where today falls within their start and end period. Or, distinct customer cout for same, or distinct ID count for same.

What I ultimatively trying to achieve is a table visual that looks like this

	Current Value (Today)	prior month	change in %	prior year	change in %
Amount
Customer
ID (License)

Of course, I can create a ton of individual measures to do this, i.e. for current, one for each item (Amount, Customer, License) * two  (Value and percentage change) for each Period (current, prior month, prior year). My main challenge, I've got a lot more of these groups than three... so quite a few measures to create. 

I'm wondering though, whether it would be possible to generate only one measure per item and have the meassure react to the column hadline. Is there an easier way to achieve what I need to do? 

Thanks for your help. 

Thanks. 

[v-luwang-msft]

Hi @Anonymous ,

Pls share your pbix file ,remember to remove confidential data.

Best Regards

Lucien

[Anonymous]

Thanks Lucien 

That's a little tricky. All the data are pulled in via API, and without the connection there wouldn't be any tables. Or is there a way to still create an annonymised file? Thanks Mark