Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everybody!
My issue is simple: i have the next formula that works perfectly in Power BI:
CALCULATE ( MIN(DATES[Year-Week]), DATESINPERIOD(DATES[FECHA],TODAY(),-1 ,DAY), ALL ( DATES ) )
When i try to use it in the same table but in Power Pivot, i get the next error (translated):
The MIN function accepts an argument whose evaluation is numbers or dates and can not work with values of the String type.
Any ideas?
Thanks in advance!
Hi,
What the type of DATES[Year-Week] in PowerPivot? Check it.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
116 | |
102 | |
77 | |
77 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |