Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
I am trying to do a dynamic KPI that would depend on the dates selected in the slicer. The problem I have is that When I select a single month, the values are being displayed correctly but when selecting a single Month but never being aggregated when selecting more than 1 month.
The formulas are just standard sth like:
1.Calculate(distinctcount(table[id]),dim_dates(full_date))
2.calcuate(distinctcount(table[id]),sameperiodlastyear(full_date))
within the kpi I have:
1. First Formula
2. MonthName
3. Second Formula
Thank you for your help!
Solved! Go to Solution.
Hi Dale,
The data was meant to be aggregated monthly with a slicer allowing to select a specific range of months, not sure what's not clear. It looked like SAMEPERIODLASTYEAR had some problems in my case scenario and used PARALLELPERIOD function instead which worked perfectly.
Thanks!
Hi @Anonymous,
Please share a sample. Your image is corrupted.
What kind of "aggregated" do you expect? You have a month in the KPI. Can the aggregation be applied more than one month?
Best Regards,
Dale
Hi Dale,
The data was meant to be aggregated monthly with a slicer allowing to select a specific range of months, not sure what's not clear. It looked like SAMEPERIODLASTYEAR had some problems in my case scenario and used PARALLELPERIOD function instead which worked perfectly.
Thanks!
User | Count |
---|---|
127 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |