power bi
1 Topic
Notebook with sempy - giving a date range for filters
Hi All, I have sempy working in Notebook and can pass filters as explained in Microsoft documentation. filters = { "TestData[Prodct]": ["ABC1"] #,"State[State]": ["FLORIDA", "NEW YORK"] } df_measure = fabric.evaluate_measure( # Dataset name "FabricTraining-NewModelForUsers" # Measure ,"Sum of Price" # Group By ,["TestData[Prodct]"] # Filters ,filters=filters ) df_measure The above example work fine. My question : How can I pass a date range using this filters dictionary technique? e.g. For Jan 2024 dates - do I need to list each date? That would make it dificult if the date range spans starting part of a month and ending part of another month. Any suggestions?Solved3KViews0likes5Comments