Forum Discussion
Helper IIICalculated columns based on user defined time periods
Hi,
I want to create a table which shows values and calculation based on user defined time periods.
The following would be user input -
T1(From), T1(To), T2(From), T2(To)
The difference and % Gain/Loss columns are to be calculated on basis of user input.
The screenshot below shows the desired output -
Refer if this can help.
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges
Connect on Linkedin
4 Replies
- amitchandak
Super User
Refer if this can help.
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges
Connect on Linkedin
sayali_deshmukhHi amitchandak
Thanks for your response. This was really helpful.Is there any way to create new measures for multiple columns (for eg - qty, value etc) at the same time ? (rather than writing new measure for each coulumn)
- amitchandak
No.
You can create a summarize table.which can have all the measures at a required level. But that is another addition in between.