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.
Hello,
I want to create a measure that shows me the values before the 01.07.2020 and a second one that shows me the values before the 01.07.2020 (see appendix).
-> CALCULATE([A Number Net],FILTER('qry_GivenOrders2016-2020','qry_GivenOrders2016-2020'[A_D_GIVER].[Date]>01.07.2020)) -> the function does not work
-> CALCULATE(SUM('qry_VergebeneAufträge2016-2020'[A_ZAHL_NETTO]),FILTER('qry_VergebeneAufträge2016-2020','qry_VergebeneAufträge2016-2020'[A_D_VERGABE - Jahr] in {2016,2017,2018,2019})) -> the function works but is not helpful.
Translated with www.DeepL.com/Translator (free version)
_________________________________________________________________________________________________________________________________
ich möchte ein Measure erstellen die mir die Werte vor dem 01.07.2020 anzeigt und eine zweite die mir die Werte vor dem 01.07.2020 anzeigt (siehe Anhang).
-> CALCULATE([A Zahl Netto],FILTER('qry_VergebeneAufträge2016-2020','qry_VergebeneAufträge2016-2020'[A_D_VERGABE].[Date]>01.07.2020)) -> die Funktion funktionier nicht
-> CALCULATE(SUM('qry_VergebeneAufträge2016-2020'[A_ZAHL_NETTO]),FILTER('qry_VergebeneAufträge2016-2020','qry_VergebeneAufträge2016-2020'[A_D_VERGABE - Jahr] in {2016,2017,2018,2019})) -> die Funktion funktionier ist aber nicht hilfreich.
Solved! Go to Solution.
Hi @DagdasAlbag
I'm not sure I understand and would need more details but try this. Change the inequality sign if necessary to adapt it to your needs:
CALCULATE (
[A Number Net],
FILTER (
'qry_GivenOrders2016-2020',
'qry_GivenOrders2016-2020'[A_D_GIVER].[Date] > DATE ( 2020, 01, 07 )
)
)
It is recommended to use a date table instead of the auto Date/Time feature
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Hi, @DagdasAlbag , you may try,
CALCULATE (
[A Number Net],
'qry_GivenOrders2016-2020'[A_D_GIVER].[Date] > DATE ( 2020, 01, 07 )
)
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Thanks a lot! it worked.
Hi, @DagdasAlbag , you may try,
CALCULATE (
[A Number Net],
'qry_GivenOrders2016-2020'[A_D_GIVER].[Date] > DATE ( 2020, 01, 07 )
)
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Hi @DagdasAlbag
I'm not sure I understand and would need more details but try this. Change the inequality sign if necessary to adapt it to your needs:
CALCULATE (
[A Number Net],
FILTER (
'qry_GivenOrders2016-2020',
'qry_GivenOrders2016-2020'[A_D_GIVER].[Date] > DATE ( 2020, 01, 07 )
)
)
It is recommended to use a date table instead of the auto Date/Time feature
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |