Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
107 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |