Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi all,
I need to create a measure for the following simplified scenario.
In my data set there is a date column and a value calumn. There is one record per day ( exccluding weekends and hilodays ) in this dataset.
In my visualizaation I have to skip first 252 days (first year ) , and for any given date after that divide the value for that date by the value for the day 252 prior to that date.
example
Date Value
5/5/2016 ( start date) 101
5/6/2016 99
...
5/5/2017 105
5/6/2017 103
....
------------------------------------------------------------------------------------------------------------------
My visualtion should display the following . Please note I don't wnat to show any records prior to 5/5/2017 in the visualization because there is no data for dates prior to 5/5/2016 in the dataset (Date - Year ago)
5/5/2017 1.039 (calculation is : 105/101)
5/6/2017 1.040 (103/99)
........
I hopw I was able to exxplain the requirment clearly. Thank you for you help.
See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
21 | |
15 | |
14 | |
11 | |
7 |
User | Count |
---|---|
26 | |
24 | |
12 | |
11 | |
10 |